Hi, because of the semicolon following the table name in your .import - command. Remove it.
Martin Phil Hibbs wrote: > I'm doing this in SQLite: > > sqlite> .separator tabs > sqlite> create table head > ...> ( id varchar(10) > ...> , tplnr varchar(20) > ...> , plnal varchar(2) > ...> , ktext varchar(40) > ...> , arbpl varchar(10) > ...> , werks varchar(4) > ...> , verwe varchar(1) > ...> , vagrp varchar(3) > ...> , statu varchar(1) > ...> , sttag varchar(8) > ...> , strat varchar(6) > ...> , batchno varchar(3) > ...> ); > sqlite> .import C:\HEAD.txt head; > Error: no such table: head; > sqlite> .schema > CREATE TABLE head > ( id varchar(10) > , tplnr varchar(20) > , plnal varchar(2) > , ktext varchar(40) > , arbpl varchar(10) > , werks varchar(4) > , verwe varchar(1) > , vagrp varchar(3) > , statu varchar(1) > , sttag varchar(8) > , strat varchar(6) > , batchno varchar(3) > ); > > Any idea why I'm getting "no such table"? > > Phil Hibbs. > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
