Re: [sqlite] Importing CSV File Into Table
Thanks all, that fixed my issue and all imported successfully. I knew I was doing something stupid, but wasn't sure. > -Original Message- > From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users- > boun...@sqlite.org] On Behalf Of Swithun Crowe > Sent: Tuesday, November 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 error > TJM> that the table does not exist. This is on SQLite 3.6.4 (required > TJM> to use this version). See below for details: > > TJM> sqlite> .import /csv/iv_codes.csv MasterChargeList; > TJM> Error: no such table: MasterChargeList; > > Try it without the semi colon at the end. Lines that start with a . don't > need a ; > at the end. > > Swithun. > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users Disclaimer This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of St. Claire Regional Medical Center. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing or copying of the email is strictly prohibited. If you received this email in error please notify the St. Claire Regional Helpdesk by telephone at 606-783-6565. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Importing CSV File Into Table
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 part of the table name. Use: .import /csv/iv_codes.csv MasterChargeList Regards, Clemens > Disclaimer *** DISCLAIMER *** This e-mail contains public information intended for any subscriber of this mailing list and for anybody else who bothers to read it; it will be copied, disclosed and distributed to the public. If you think you are not the intended recipient, please commit suicide immediately. These terms apply also to any e-mails quoted in, referenced from, or answering this e-mail, and supersede any disclaimers in those e-mails. Additionally, disclaimers in those e-mails will incur legal processing fees of $42 per line; you have agreed to this by reading this disclaimer. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Importing CSV File Into Table
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 /csv/iv_codes.csv MasterChargeList; TJM> Error: no such table: MasterChargeList; Try it without the semi colon at the end. Lines that start with a . don't need a ; at the end. Swithun. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
