importing csv files

E

Eric

i received several csv files that I urgently need to import
into an access table. When opening the cvs files they open
in excel, is there a way via code ti import all these files?
Does anyone has sample code that shows you how this works?

Many thanks for any help....

Eric
 
J

John Nurick

Hi Eric,

Just launch Access, open your database (or create a new blank database) and
then use File|Get External Data|Import...

This allows you to import data from a CSV file into a new table or an
existing table.
 
Top