RE: [sqlite] Problem importing csv file

2006-05-10 Thread André Goliath
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

Re: [sqlite] Problem importing csv file

2006-05-10 Thread drh
> > 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 >

RE: [sqlite] Problem importing csv file

2006-05-10 Thread Patton, Eric
, 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

RE: [sqlite] Problem importing csv file

2006-05-10 Thread André Goliath
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