Import a columnar report text file into access 2003

  • Thread starter Thread starter Guest
  • Start date Start date
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

....
 
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.
 
Back
Top