.separator ","
.import myPath/myCSVfile myTable
We use a "import" file with these commands.
On 3/10/2011 2:32 PM, jcilibe...@comcast.net wrote:
> Thanks, but doesn't seem to work:
>
>
> I used command>
> ----- Original Message -----
> From: "Gerry Snyder"<mesmerizer...@gmail.com>
> To: "General Discussion of SQLite Database"<sqlite-users@sqlite.org>
> Sent: Thursday, March 10, 2011 12:39:33 PM
> Subject: Re: [sqlite] .import FILE TABLE
>
> On 3/10/2011 1:28 PM, jcilibe...@comcast.net wrote:
>> Hello, thanks but adding separator "," doesn't seem to work.
>
> I tried the following commands:
>> .import separator "," myPath/myCSVfile myTable
>> . import separator , myPath/myCSVfile myTable
>> . import myPath/myCSVfile myTable separator ,
>> . import myPath/myCSVfile myTable separator ","
>
> None worked: any ideas? Examination of the myCSVfile.txt shows [1, "Jack",
> "Sammamish"]
>>
>> Unbelievably active user group!
>>
>>
>> I have been unable to import a CSV text file from MS Access to sqlite:
>> 1. Created a small table (3 fields and 1 record) in Access and exported it
>> to a CSV text file named "myCSVfile.txt"
>>
>>
>> 2. Transferred from PC to Mac. Opened file "myCSVfile.txt" ...looks OK eg:
>> [1, "Jack", "Sammamish"]
>>
>>
>> 3. Created a new DB ("myDB") and table ("myTable") in SQLite Database
>> Browser eg: [ID:primaryKey Name:text City:text]
>>
>>
>> 4. Opened the DB in terminal with> sqlite myPath/myDB
> Does adding the line:
>
> .separator ","
>
> help?
>
>> 5. Entered command> .import myPath/myCSVfile myTable
>>
>>
>> Always get back message: "line 1: expected 3 columns of data but found 1"
>>
>>
>> Help! I've read many archived posts...so I know this should work.
>> _______________________________________________
>> sqlite-users mailing list
>> sqlite-users@sqlite.org
>> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>>
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
> _______________________________________________
> sqlite-users mailing list
> sqlite-users@sqlite.org
> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
>
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
