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
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
Make sure your separator is the ,
http://www.sqlite.org/sqlite.html
On 3/10/2011 12:28 PM, jcilibe...@comcast.net wrote:
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
On 3/10/2011 1:28 PM, jcilibe...@comcast.net wrote:
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.
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
of SQLite Databasesqlite-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
Larry Siden lsi...@... writes:
What is the format of the file? I cannot find it documented anywhere.
It is a csv file with the same fields in the same order as your table has.
You can set the separator of the csv this way
.separator \t
(\t == tab, default is |)
Oliver
What is the format of the file? I cannot find it documented anywhere.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users