On Mon, Aug 31, 2009 at 10:02 AM, Kavita Raghunathan<kavita.raghunat...@skyfiber.com> wrote: > Hi, > I'm evaluating SQLite to be used as a small embedded database in > a linux environment for Skyfiber Inc. What is the best way to import data > into it ?
.import > I have a bunch of entities and attributes in an excel spreadsheet. > Could I import CSV ? - create your db with the desired columns - make sure your Excel sheet has the same columns as your db - export csv from your Excel sheet - start your db and then .import > What should be the columns (where can I read about this etc) www.sqlite.org > Regards, > Kavita > _______________________________________________ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users