Import/Export CSV from SQLite from C# code

Question

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?

Andrey · Accepted Answer · 2010-03-05 11:00:03Z

5

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.

answered Mar 5, 2010 at 11:00

Andrey

60.3k12 gold badges127 silver badges169 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

abmv · Accepted Answer · 2010-03-05 11:03:20Z

1

You could use the file helpers library if you want also.And well use the ado.net functionality too.

answered Mar 5, 2010 at 11:03

abmv

7,10317 gold badges65 silver badges105 bronze badges

Collectives™ on Stack Overflow

Import/Export CSV from SQLite from C# code

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related