joshua wojnas <josh...@...> writes: > > how do I load a csv file or what is the simplest text file to load > into sqlite3?
1. sqlite3 yoursqlitedatabasename 2. .import yourtextfile yourtablename (see .h for documentation) ready but what you need is: - an existing sqlitedb (step1 already creates the db) - the table in the sqlitedb where you want to insert your data (you need knowledge how to plan a "good" db and about the tool to do it (SQL)) - an adequate structure of yourtextfile (reliable delimiter) - no header in yourtextfile - choose the delimiter in sqlite3 before importing (ie: .separator \t for TABS, standard in sqlite is |) > what would be the best format to use I use text pad and open office > calc. Also open office base. the best format is a text file last hint: read the documentation Oliver _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
