Re: [sqlite] .import FILE TABLE

2011-03-11 Thread jciliberti
Thank you, thank you, thank you. - Original Message - From: Jim Morris jmor...@bearriver.com 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 file with

[sqlite] .import FILE TABLE

2011-03-10 Thread jciliberti
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

Re: [sqlite] .import FILE TABLE

2011-03-10 Thread jciliberti
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