View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
amolchopra amolchopra is offline
external usenet poster
 
Posts: 1
Default automatic import of .csv file into access database

I have a .csv file. I have to read it and import the contents into one
of the DB tables. I have already worked on the ODBC part. Have opened
the file in read mode. This is a "C" application and the user has to
provide the files name at the command prompt. I can read the file name,
can open the file have connected to the DB. All I am looking for is
some command (or SQL query) that I can use in my C program to import
its contents to the table. Can some one please help??