Text on Multiple Rows of Text File

S

SheilaG

I have a text file that I am trying to import into Access that has multiple
rows of data for each record (kind of like an address label might look like).
The text file is fixed width, not delimited. How can I pull the multiple rows
of data into one record?
 
J

Jeff Boyce

Sheila

First, are you quite certain that the "multiple rows of data" belong in "one
record"? This is a question about normalization. Often, text file data is
not normalized. Access, a relational database, "expects" well-normalized
data to get the best use of its features/functions.

Have you looked at using Word or Excel to initially 'parse' the data into
fields before importing into Access?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top