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?
- [sqlite] Importing delimited text table into SQLite3 John D. Tiedeman
- Re: [sqlite] Importing delimited text table into SQ... Clark Christensen

