if you can send that to me On 1/30/06, Nemanja Corlija <[EMAIL PROTECTED]> wrote: > On 1/30/06, Clint Bailey <[EMAIL PROTECTED]> wrote: > > Is it possible to import tab delimited data into sqlite in order to > > start testing? > You can use sqlite3 command for that. Something like this: > > E:\SQLite>sqlite3.exe test.db3 > SQLite version 3.2.6 > Enter ".help" for instructions > sqlite> CREATE TABLE test(a, b, c, d); > sqlite> .mode tabs > sqlite> .import "tab_delimited_data.txt" test > sqlite> .mode column > sqlite> SELECT * FROM test LIMIT 10; > > Of course, replace "test" table above with something that matches > number of columns in your input file. > There's a patch attached to > http://www.sqlite.org/cvstrac/tktview?tn=1506 that adds 2 flags to > .import. If you are on windows I can send you sqlite3.exe compiled > with that patch if you need it. > > -- > Nemanja Corlija <[EMAIL PROTECTED]> >
-- With Best Regards, Vishal Kashyap. http://www.vishal.net.in
