Text on Multiple Rows of Text File

  • Thread starter Thread starter SheilaG
  • Start date Start date
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?
 
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
 
Back
Top