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

Reply via email to