DoCmd.TransferDatabase Error

  • Thread starter Thread starter DaveE
  • Start date Start date
D

DaveE

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
 
Back
Top