Import a columnar report text file into access 2003

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Denny - 10 Sep 2005 19:19 GMT

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

...

Reply to this Message

Douglas J. Steele - 10 Sep 2005 19:27 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I need to import a .txt file with the following format into access 2003
>
[quoted text clipped - 7 lines]
>
> ...

Reply to this Message