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