Importing .txt (tab delimited) file into Access 2007

[bcn1988]

I have a text file named "Listing_12032012" with the file path:



C:\Documents and Settings\htq972\Desktop\Work Files\POR Reports\POR & PMOR Files\12-03-2012\

So the full path to the file is:

C:\Documents and Settings\htq972\Desktop\Work Files\POR Reports\POR & PMOR Files\12-03-2012\Listing_12032012

I then have a table in Access 2007 named "ca-Project List"


If I follow the import wizard, this is the following steps:

1) External Data > Import Text File
2) Browse > Select: C:\Documents and Settings\htq972\Desktop\Work Files\POR Reports\POR & PMOR Files\12-03-2012\Listing_12032012
> Select Append a copy of the records to the table > Select: "ca-Project List"
3) Select: "Delimited - Characters such as comma or tab separate each field" > Next
4) Select: Tab > Select: First Row Contains Field Names > Select Text Qualifier: "
5) Next > Finish

I need the VBA code to automate this task! Can someone please help!

[alansidman]

Here is a simplified tutorial on how to do it.

http://www.datawright.com.au/access_...text_files.htm

Post back if you have issues or get stuck.

Alan