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?

Reply via email to