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
