Import CSV data to Sqlite. Import CSV data to SQLite.

Import CSV data to Sqlite. Import CSV data to SQLite.

When you do the data import, you just need to clarify the two o'clock.

1, Extract Title as field name.

2, data is written to the data pool.

Here SQLite is good for us to solve this kind of problem.

The Fieldsnames attribute solves the problem of extracting title very high, while the data pool, SQLite insert accepts the list dataset of the inclusion tuple. Here a tuple is a row of data.

Finally, the only thing we want to achieve is a section of SQL:

DROP TABLE IF EXISTS [TABLE];CREATE TABLE [TABLE](COL1,COL2,COL3);INSERT  into [TABLE](COL1,COL2,COL3)VALUES(?,?,?);

FORMAT a bit:

DROP TABLE IF EXISTS [{0}];CREATE TABLE [{0}]({1});INSERT  into [{0}]({1})VALUES({2});

Class Library source code see Https://github.com/WandyYing/csv2Sqlite