Import/Export CSV from SQLite from C# code
14,613
you can create OleDbConnection
to CSV file (just google it, it is very easy) then load rows to DataSet, then put that dataset into Sqlite by SqliteConnection
. Few lines of code.
Author by
SysAdmin
Updated on June 20, 2022Comments
-
SysAdmin almost 2 years
I am trying to figure out an eazy way to load CSV file into SQLite DB using System.Data.SQLite
I saw commandline way to do that i.e
.Import mydata.csv mytable
But I need to do this via C# code. Any Idea?