Help With Text Files

mmatsumura

Member
Joined
Sep 8, 2003
Messages
12
Let me first say "Thank You" to all those who have replied to previous postings!

Okay, here is what I have tried to do via a VB.NET Windows application-

1. Read .txt files from diskette(s) and store them in a database or dataset;

The .txt file is space delimited. An example looks like this -
(12 spaces+15 spaces+20 spaces+2 spaces)

Mike Smith 123 Something St. WA
David Watertown 23 My Ave. FL
Marianne Jones 23232 Her Pl. TX
Ed Horse 1-A Horse St. NY

I will need to read the text file from multiple diskettes, each one using the same file name. For example, the file on disk 1 is "SomeData.txt" which is 3000 lines long. The second disk is using the same file name but has another 3000 lines. Same for disk 3-6.

2. Read some data from an Excel worksheet, via diskette or email, and append that data to a database or dataset that was read after the above procedure.

3. Once the data was appended, regenerate a diskette set.

So, Ive tried and tried again but havent been able to make anything work. As I stated I wish this be a VB.NET Windows application (which I am primative to) and would greatly appriciate everyones help.


In advance,

Thank You
 
Back
Top