I had a lot of trouble with trying to import into SQL Manager from csv
files. Per some earlier advice, I began inputting through the console
instead. But I did figure out a way to cut down on the time. I've
been making cookie-cutter iPhone apps (a series of rules of legal
procedure where the rules are in a sqlite database) so what I did was
make a template of sorts. In the left column is the INSERT INTO etc.
In the middle column is the text I wish to insert. In the right column
is the '); When finished, I collapsed the table (plus I had to get
rid of unwanted returns), then copied the whole thing and pasted it
into the input box (or whatever it's called) on the console. Works
like a charm. Then I look for error messages and fix things until
there are no more errors. For the next app, I tinker with the template
to make any changes required for the new data, then paste the new data
into the middle column and off we go again.
I've attached a file with a few rows so you can see what I'm talking
about.
Jimmy Verner
www.vernerlegal.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
