Importing Text (1 Viewer)

ayeshamiah

Registered User.
Local time
Today, 16: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
 

Neal

Registered User.
Local time
Today, 16:18
Joined
Feb 17, 2000
Messages
116
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

Registered User.
Local time
Today, 16:18
Joined
May 24, 2000
Messages
20
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

New member
Local time
Today, 16:18
Joined
May 31, 2000
Messages
5
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

Registered User.
Local time
Today, 16:18
Joined
May 24, 2000
Messages
20
That the one Iused thanks min, I'll find my way round access eventually
 

jasn_78

Registered User.
Local time
Tomorrow, 03:18
Joined
Aug 1, 2001
Messages
214
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

Top Bottom