Have you tried PRAGMA integrity_check 'ing your DB?
Have you tried with a clean DB / new Table?
-Original Message-
From: Patton, Eric [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 3:59 PM
To: 'sqlite-users@sqlite.org'
Subject: RE: [sqlite] Problem importing csv file
Andre
>
> Time,Easting,Northing
> 184102229,651807.39,5165628.749959
> 184102230,651807.890587,5165628.680512
> 184102231,651807.890878,5165628.668937
> 184102232,651807.890587,5165628.680512
> 184102233,651807.890587,5165628.680512
> 184102234,651807.890587,5165628.680512
>
, 2006 10:44 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] Problem importing csv file
First of all, remove the header line from your CSV.
SQLite expects only data, no headers.
-Original Message-
From: Patton, Eric [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 3:04 PM
First of all, remove the header line from your CSV.
SQLite expects only data, no headers.
-Original Message-
From: Patton, Eric [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 10, 2006 3:04 PM
To: 'sqlite-users@sqlite.org'
Subject: [sqlite] Problem importing csv file
I can't seem to
4 matches
Mail list logo