Duuh. The trailing ";" needs a space, otherwise the .import command thinks ";" is part of the table name. Probably not a valid character for a table name anyway, so I guess that goes under the category "unwanted features".
Cheers Balthasar T. Indermuehle UNSW Antarctic Astrophysics Group > -----Original Message----- > From: Balthasar Indermuehle [mailto:[EMAIL PROTECTED] > Sent: Dienstag, 21. März 2006 18:11 > To: sqlite-users@sqlite.org > Subject: [sqlite] .import problems > > Hi all, > > I'm trying to import a rather large file with the .import > command into a version 3 sqlite DB file. I have created the > table named data, all fields are numeric, I type ".import > data.csv data" and I get the sqlite3 error > "Error: No such table: data;" > > Any ideas anyone? > > thanks > > > Balthasar T. Indermuehle > UNSW > Antarctic Astrophysics Group > > >