--- "John D. Tiedeman" <[EMAIL PROTECTED]> wrote: > I,m trying to import a 6-col. tab delimited table into a > 6-field SQLite3 > table: > .import busrides.txt rides > Message: line 1: expected 6 columns of data but found 1 > I tried adding "delimiters tab" with no effectt then > "delimited by tab". > Then I copied the first few lines into a new file, > busridessc.txt and > replaced the tabs with semicolons and used the delimiter > clause with > ";". Same message. Then I created a 1-col. table with a > few dates in it > and successfully imported into a new 1-field SQL table. I > never had this > problem with SQLite2. What do I have to do to get the > delimiters > recognized as they were in the old COPY command? >
How about .separator "\t" to set the delimiter to a tab? -Clark
