Import a columnar report text file into access 2003

G

Guest

I need to import a .txt file with the following format into access 2003

field1: data1a
field2: data2a
field3: data3a

field1: data1b
field2: data2b
field3: data3b

....
 
D

Douglas J. Steele

One way would be to use VBA to read the file line by line, and create INSERT
INTO SQL statement after you've read each record.

Another would be to import the data as is to a temporary table, and then try
to transfer the data from that temporary table into the desired table. Not
sure you'd be able to do this without some manual intervention, though.
 

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 Text File Into Access 0
Importing Multiple Excel fiels to one Access Database 4
Import from Excel to Access 2
Importing a delimted file that includes the field headings 1
Importing/Table 1
CSV Import Rename Broken? 1
Import File With Multiple Delimiters 2
Shift several columns in table 4

Top