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