how to create table from the .txt /.csv/.tsv file ? and from the datatable ?

Question

hi...

I'm reading some .csv/.txt file ...using ODBC ...

To store those data I read it in datatable .

then I create table in database manualy....

I want to create table automaticaly according to file column shcema...

How can I do that in C# code ?

Answer 1

Hi .netaholic,

you can refer below link for creating database schema from datatable.

http://darrylagostinelli.com/2011/06/27/create-a-sql-table-from-a-datatable-in-c-net/

---

Thanks and Regards, Shailesh B. Davara