我也遇到同样问题,官网有解决方案
createtable的时候直接导入
http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles==============================================================
Import using a virtual table
The attached file csvfile.zip includes an implementation of a virtual table to read CSV files.
It needs to be compiled as an sqlite extension and loaded using the ".load" mechanism.
Then use it like this:
CREATE VIRTUAL TABLE [<database>.]<table_name>
USING CSVFILE( ?file? [, <charset> [, <delims>] ] );
* <charset> is the character set name to pass to iconv(). The default character set is "CP1252" (Windows Western Europe).
* <delims> is a string where the first character is the csv file field delimiter and the second character is the string delimiter. The default field delimiter is the ";" character and the default string delimiter is the "\"" character.
You may need to tweak the code for your system.
Correction for attachment csvmbpg.tgz: In file virtual_csvmbpg.c:
char charset[32] = "ISO-8859-1";
instead of
char charset[32] = "";