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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Import errors importing Text into existing table, header vs no hea 3
How can I import non-delimited text file into access 3
importing multiple lines of text into a field in table 1
export database to a text file 1
Import Text file with Pipe Delimited - 2007 4
Importing Problem 1
Importing Text Files Into Access 1
Text import not WYSIWYG 1

Top