Pull info from txt files

  • Thread starter Thread starter Ron
  • Start date Start date
R

Ron

Does anyone know how I might be able to harvest some data
from text files?

I have an old application that stores everything in text
files, one per customer. Within the file are numbered
lines, each with specific information. For instance line
112 might be customer name, line 114 account number, etc.

Since there are thousands of these text files, it isn't
practical to go in manually and do it. I was hoping
there would be some way Access could.

Any ideas or suggestions?

Thanks
rt
 
I have looked at several of the text files and they all
have the same format. It starts with 3 lines of header
and from then on, it is line-number comma value. A
partial example below.

"Smith","12345"
"Y","","CA","1","0","0","0"
"1","-1","-1"
6,CA
215,Y
217,M
221,N
245,Y
271,26-50
280,JOHN
282,SMITH
300,01/03/2003
305,04/01/2003
320,100 MAIN ST.
322,SAN DIEGO, CA 12345
350,B
355,555-123-0987
420,CONVENTIONAL WITHOUT 5 YEAR OPTION
425,D
455,389.23
520,Y


etc, etc... Hundreds of lines per file. I am not trying
to harvest all the data, just specific lines
(280,282,320,322,etc).

Suggestions?

Thanks again,
rt
 
Back
Top