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