Importing Text

ayeshamiah

Registered User.
Local time
Today, 19:18
Joined
May 24, 2000
Messages
20
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
 
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.
 
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
 
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
 
That the one Iused thanks min, I'll find my way round access eventually
 
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.
 

Users who are viewing this thread

Back
Top Bottom