[DB-SIG] inserting or importing csv file to a sqlite3 connected table

Carsten Haese carsten at uniqsys.com
Wed Sep 12 20:08:43 CEST 2007


On Wed, 2007-09-12 at 17:04 +0000, ca17005 at bellsouth.net wrote:
> Very new at this.  If I can get sample code for converting a csv file
> to one that will accept SQL commands then I have gotten over a big
> hump.

Take a look at the second code example in
http://informixdb.blogspot.com/2007/04/power-of-generators-part-two.html . (Search for the phrase "consider the following naive data loader" to jump to the example.)

That example is written for the Informix database and assumes the
columns are delimited with "|", but it'll translate easily to sqlite and
comma delimiters.

Hope this helps,

-- 
Carsten Haese
http://informixdb.sourceforge.net







More information about the DB-SIG mailing list