On 6/17/08, Alberto Simões <[EMAIL PROTECTED]> wrote: > Hi, Folks > > I have a text file with 18 399 392 lines. Each line contains five > fields. Four are a compound key, the other is just data. > What is the best way to import this to sqlite? > > I am thinking on creating another text file with 18 399 392 INSERT > commands. > Would that be the best method?
Look at the .read command in the sqlite3 command line program. > > (by the way, I am expecting to have bigger tables in the near future) > > Thanks > Alberto > > > -- > Alberto Simões > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor http://punkish.eidesis.org/ Nelson Institute for Environmental Studies http://www.nelson.wisc.edu/ Open Source Geospatial Foundation (OSGeo) http://www.osgeo.org/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
