On Mon, Aug 31, 2009 at 10:02 AM, Kavita Raghunathan<[email protected]> 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 > [email protected] > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Puneet Kishor _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
