On 10 Jan 2012, at 5:13pm, rpallotta wrote: > Thanks for the reply, but do I necessarily need to use php? I'd like the > ability to do it from the SQL command window using a variation of the > .import command, if possible.
You can't. The .import command can't cope with such things. Either write a program to do the importing, or before you do the importing use an editor to massage your text file into a form where all columns are separated by the same separator character. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
