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 MasterChargeList(charge_code TEXT, mnemonic TEXT, description TEXT); CREATE TABLE OncologyChargeList(charge_code TEXT, mnemonic TEXT, description TEXT); sqlite> .import /csv/iv_codes.csv MasterChargeList; Error: no such table: MasterChargeList; Jerry Tilsley St. Claire Regional Medical Center Sr Systems Analyst | Interfaces ________________________________ 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
