Re: [sqlite] Importing CSV File Into Table

2012-11-13 Thread Tilsley, Jerry M.
r 13, 2012 9:23 AM > To: General Discussion of SQLite Database > Subject: Re: [sqlite] Importing CSV File Into Table > > Hello > > TJM> I am trying to import some data from a csv file to an existing > TJM> table called MasterChargeList. But this is failing with the err

Re: [sqlite] Importing CSV File Into Table

2012-11-13 Thread Clemens Ladisch
Tilsley, Jerry M. wrote: > sqlite> .import /csv/iv_codes.csv MasterChargeList; > Error: no such table: MasterChargeList; The internal commands of the sqlite3 command-line tool that begin with a period are not delimited with a semicolon, so the semicolon that you have entered is interpreted as

Re: [sqlite] Importing CSV File Into Table

2012-11-13 Thread Swithun Crowe
Hello TJM> I am trying to import some data from a csv file to an existing table TJM> called MasterChargeList. But this is failing with the error that the TJM> table does not exist. This is on SQLite 3.6.4 (required to use this TJM> version). See below for details: TJM> sqlite> .import

[sqlite] Importing CSV File Into Table

2012-11-13 Thread Tilsley, Jerry M.
All, I am trying to import some data from a csv file to an existing table called MasterChargeList. But this is failing with the error that the table does not exist. This is on SQLite 3.6.4 (required to use this version). See below for details: sqlite> .mode csv sqlite> .schema CREATE TABLE