Re: [sqlite] sqlite3.dll wrapper to import .csv file

[Simon Slavin]

On 29 Feb 2012, at 4:53am, Rick Guizawa  wrote:

> Hi All, I am using sqlite3.dll in my c# winform app, I was wondering if
> anyone knows how to import .csv file into sqlite db table using c#
> sqlite3.dll wrapper function.

SQLite has no functions for handling .csv files.

You can either write your own code to read the .csv file and make a database 
out of it, or you can use the sqlite3 command-line shell tool (which is its own 
stand-alone program, and not part of the SQLite library) to do it.  You can 
find the tool here:

http://www.sqlite.org/download.html

and documentation for it here:

http://www.sqlite.org/sqlite.html

Simon.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] sqlite3.dll wrapper to import .csv file

[Rick Guizawa]

Hi All, I am using sqlite3.dll in my c# winform app, I was wondering if
anyone knows how to import .csv file into sqlite db table using c#
sqlite3.dll wrapper function. Thank's for any help I get.
Cheers,
Rick
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users