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

Reply via email to