When I run the code to import a table from an ODBC db I get an error that the
destination table doesn't exist, "tblCustomer doesn't exist". If I create an
empty tblCustomer table, the error says "tblCustomer1 doesn't exist". And on
it goes. What am I missing. I thought it would just create the table.

I just got done going through something similar with TransferText (fields
rather than tables though). As it turns out I missed the True argument for
specifying that the fields already existed.

I got my answer easily enough (link below), but I haven't been able to find
anything on TransferDatabase.

Upon searching I was reading a thread somewhere where someone had the same
problem, but it was left unresolved, with at least one opinion that
TransferDatabase was buggy and had insufficient help.

http://support.microsoft.com/kb/142186


Hardly an answer, but maybe something I mentioned will trigger for you...

--
Jack Leach
www.tristatemachine.com

- "First, get your information. Then, you can distort it at your leisure."
- Mark Twain


"DaveE" wrote:

> When I run the code to import a table from an ODBC db I get an error that the
> destination table doesn't exist, "tblCustomer doesn't exist". If I create an
> empty tblCustomer table, the error says "tblCustomer1 doesn't exist". And on
> it goes. What am I missing. I thought it would just create the table.