SELECT * INTO table 'IN' database FROM table;

This works in ACCESS and copies a table from one ACCESS database to another.

However, this does not work in SQL2000 but give the following error.