On Tue, 14 Sep 2010, Jay A. Kreibich wrote: > If that's a copy-paste from a default sqlite3 session, the single quotes > are part of the value. i.e. you have four-character values, such as > "'ID'".
Jay, That's because I used single quotes to delimit strings in the original .csv file. Removing them in the .csv and re-importing solves the problem. I must have not used any quotation marks on text strings in prior data imports for other databases after changing the ',' separator to '|' and not remembered that's what I had done before. Thanks, Rich _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
