Subj : Re: Database program to just work with text files?
To   : comp.os.linux
From : drh
Date : Sun Aug 29 2004 09:45 am

adams_forum@yahoo.ca (Adam) wrote in message news:<6f1027e6.0408281538.1bb14223@posting.google.com>...
> drh@hwaci.com (D. Richard Hipp) wrote in message news:<67125085.0408241757.15eaf9de@posting.google.com>...
> > 
> > Use the ".import" command in the command-line shell.
> 
> Thanks.  That seems to be a new command which the version I got
> doesn't have; which version of SQLite do I need?  I have version
> 2.8.14.
> 
> Does the file format for .import simply have to be tab separated
> values or what?

The ".import" command is for version 3.0 only.  For tab-separated
values, you would do this:

    .separator \t
    .import  filename.txt  tabletoimportinto

You can specify any other separator you want, of course.

.