On 6 Jun 2011, at 12:41am, Kyle Malloy wrote: > After creating a Database.sqlite i then create a Table and try to past text > from a text file into the shell, but the text wraps? Im working on an iphone > app and im new to it all.
Kyle, first, do not use directional quotes in SQLite. Use the apostrophe character around strings 'Dick, Tom' don't do what is in your message like this ‘Dick, Tom’ Second, if you have lots of data in a tab-delimited format, you can read it into a database using the SQLite command-line tool. Download it from here: http://www.sqlite.org/download.html Documentation is here: http://www.sqlite.org/sqlite.html You probably want something like > sqlite3 Database.sqlite sqlite> CREATE TABLE myTable ( whatever ); sqlite> .separator "\t" sqlite> .import myFile.csv myTable Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
