automatic import of .csv file into access database

#1 (**permalink**) 09-Nov-2005, 17:51 PM

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/6966-automatic-import-csv-file-into-access.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6966
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??

*

#2 (**permalink**) 09-Nov-2005, 17:51 PM

On 8 Nov 2005 13:21:24 -0800, amolchopra@gmail.com wrote:
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6966
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=6966

>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??

Take a look at the online help for the TransferText method.

John W. Vinson[MVP]