Importing CSV files

[Steven547]

What would be a simple script or way to import a .csv file into access 2003? Would I just do a "import" from within or do it through VBA? And if through VBA, is there a "template" out there to follow? Sorry, I'm new to the "importing through VBA" so I'm trying to find examples to follow so I can learn this...

thanks!

 

[PHV]

Have a look at the DoCmd.TransfeText method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[PHV]

OOps, sorry for the typo.
Have a look at the DoCmd.TransferText method.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JBinQLD]

There are two methods - look at

docmd.transfertext

Alternatively, if you need to do anything funky with the text as it comes in look at something like

dim strLine as sring

open "Myfile.txt" for input as #1
do until #1.eof(1)
    Line Input #1, strLine
    'Do somehing with strLine
loop

Hope this helps, JB