First you need to know how to execute SQL code.
The following describes that how to execute SQL statements from c#.
http://msdn.microsoft.com/en-US/library/0k7hxwz6(v=vs.80).aspx[
^]
Then you need to read in the CSV to get the structure of the file. One such reader is available on CodeProject :-)
A Fast CSV Reader[
^]
Next you need to construct an SQL statement which creates the table. The following explains the
CREATE TABLE
command is SQL.
http://www.w3schools.com/sql/sql_create_table.asp[
^]
Then you need to execute this command against SQL.
Then you need to read the data in with your CSV reader and insert into the new table.
The following is information on the
INSERT
command.
http://www.w3schools.com/sql/sql_insert.asp[
^]