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
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
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
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
4 matches
Mail list logo