How do I import a CSV file into access 2

[leonepaolo]

Hi!

From within access I'd like to use SQL to import all the records from a .csv file to a new table.

I'd really appreciate any directions or suggestions.

Thanks in advance,
Paolo.

 

[PHV]

Have a look at the DoCmd.TransferText method.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[aristos]

Thanks, PHV. I knew that this was available *somewhere* and the Access help file was, as expected, useless...

Mike
Will BF1942 for food...

 

[CautionMP]

leonepaolo,
[tt]TransferText()[/tt] is the way to go, but if you really want to do it in SQL:

SELECT *, * INTO [i]NewTableName[/i]
FROM [i]SourceFileName[/i]#[i]csv[/i] IN [i]"TheFullPathToTheCSVFile[/i]\" "Text;FMT=Delimited;HDR=NO;IMEX=2;";

CMP

(GMT-07:00) Mountain Time (US & Canada)