Nemanja, I never knew this could happen. In one of my latest project I had to use sed to convert data into csv. Later this data was imported by import command. But the example stated here would reduce atleast one step in my project. Moreover I am only concerned that the data may not be tab limited by offcource seperated by space.
Thanks 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
