PBDBMS on www.hellobasic.com
All through ADO..
----- Original Message -----
From: "Cariotoglou Mike" <[EMAIL PROTECTED]>
To: <sqlite-users@sqlite.org>
Sent: Wednesday, December 07, 2005 9:23 AM
Subject: RE: [sqlite] how can I import CSV file into SQLite quickly
sqlite3Explorer does that
________________________________
From: John Stanton [mailto:[EMAIL PROTECTED]
Sent: Wed 07-Dec-05 8:00 AM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] how can I import CSV file into SQLite quickly
Someone somwhere must have a simple Perl script which does what you want.
JS
Robert L Cochran wrote:
I create an SQL file that has contents like this:
[EMAIL PROTECTED] elections]$ cat insert_precinct.sql
BEGIN TRANSACTION;
INSERT INTO "precinct" VALUES(1, 'Community Center 15 Crescent Road', 3,
'Greenbelt', 'Maryland', 0);
INSERT INTO "precinct" VALUES(2, 'Police Station 550 Crescent Road', 6,
'Greenbelt', 'Maryland', 0);
INSERT INTO "precinct" VALUES(3, 'Springhill Lake Recreation Center 6111
Cherrywood Lane', 8, 'Greenbelt', 'Maryland', 0);
COMMIT;
Then I fire up sqlite3 on the command line, and issue
.read insert_precinct.sql
I realize this will probably make you unhappy because it means editing
your CSV file so that each line is transformed into an sql statement.
This can be done most easily with sed (if you are a Linux or Unix
person), but you need to know sed commands and you need to be willing to
patiently experiment until the sed script applies exactly the right edits.
Bob Cochran
ronggui wong wrote:
I have a very large CSV file with 10000 rows and 100 columns.and the
file looks like the following:
"a","b","c","d",
"1","2","1","3" ,
"3","2","2","1",
......
If I use .import,It seems I have to set the variable names manually .
Is there any way to import the whole data file into SQLite quickly?
Thank you!
ronggui
