Importing Text

[ayeshamiah]

Hi all,

Can any one help

What is the best way in VBA to import a delimited text file and create a new table and how would I update this table at a later date.

thanks in advance, Ayesha

 

[Neal]

Go to your tables tab. Click on File, Get External Data, Import. That will open a wizard that will walk you through the steps for importing data, including delimited text files. You can create a table with this method, or add data to one.

 

[ayeshamiah]

I can import using the wizard no problem,
I want to be able to do this in VB

Many thanks for your help I have managed to found the command that I need to use, after trawling thru pages of help files

thanks again, Ayesha

 

[min]

It seemd we have a pretty simple solutions for table/query import/export

-------------
DoCmd.TransferText acExportDelim, , "Country Query", "C:\temp\April.txt"
DoCmd.TransferText acImportDelim, , "april", "c:\temp\april.txt"
-------------

Min

 

[ayeshamiah]

That the one Iused thanks min, I'll find my way round access eventually

 

[jasn_78]

Hi if you find anything about how to do this could you please tell me as I am trying to do the same thing at the moment and am having difficulties.