Sorry, ignore this thread. It was my mistake. I did not include single quotes around the OtherDatabase in my SELECT INTO statement.

Thanks for yor help!

>INSERT INTO only operates on one record. My select statement can easily generate hundreds of records.
>
>>In the example of the last message, instead of :
>>>dbs.Execute "CREATE TABLE ThisTable " _
>>> & "(FirstName TEXT, LastName TEXT);"
>>
>>use:
>>
>>>dbs.Execute "INSERT INTO ..."