Re: [sqlite] .import FILE TABLE

Thank you, thank you, thank you. - Original Message - From: "Jim Morris" To: sqlite-users@sqlite.org Sent: Thursday, March 10, 2011 2:40:34 PM Subject: Re: [sqlite] .import FILE TABLE .separator "," .import myPath/myCSVfile myTable We use a "import"

Re: [sqlite] .import FILE TABLE

Thanks, but doesn't seem to work: I used command > - Original Message - From: "Gerry Snyder" To: "General Discussion of SQLite Database" Sent: Thursday, March 10, 2011 12:39:33 PM Subject: Re: [sqlite] .import FILE TABLE On

[sqlite] .import FILE TABLE

Hello, 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"