I noticed that the sqlite shell won't ".import" into an attached database:
sqlite3.exe some.db sqlite> attach database 'foo.db' as foo_db; sqlite> create table foo_db.bar_tab (col1 varchar(40), col2 varchar(40)); sqlite> .import 'some_data.txt' foo_db.bar_tab Error: no such table: foo_db.bar_tab which I can work around. I thought I would add a note to the wiki http://www.sqlite.org/cvstrac/wiki?p=ImportingFiles since that limitation is not documented anywhere that I've found. But I can't find a way to register and edit that page. At least now it will be in the mailing list archives. If someone with the know-how to register on that wiki wants me to make that edit, get in touch. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
