transferdatabase

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

tthoang - 27 Apr 2007 19:22 GMT

I am using MS Access 2003. When using transferdatabase function to export
tables in an access database to Oracle. I get an error message sayin "type
mismatch". The code I type in as follows:

DoCmd.TransferDatabase "acExport", "ODBC Datababe", "ODBC;DSN=fdr1;
UID=hoant; PWD=hoant; Database=Oracle", acTable, "Source=PRB_BASIN_HEADER",
"Destination=PRB_BASIN_HEADER", "StructureOnly = False", "StoreLogin = True"

Can you help me to locate the mismatch type or if you have a working
example. Please allow me to share.

Reply to this Message

Douglas J. Steele - 28 Apr 2007 12:32 GMT

Try removing the Source=, Destination=, Structure= and StoreLogin= bits from
your code (and take the boolean values out of the quotes):

DoCmd.TransferDatabase "acExport", "ODBC Database",
"ODBC;DSN=fdr1;UID=hoant;PWD=hoant;Database=Oracle", acTable,
"PRB_BASIN_HEADER", "PRB_BASIN_HEADER", False, True

If you want named arguments in your call, you need the names to be outside
of the quotes and you need to use :=, not =

DoCmd.TransferDatabase "acExport", "ODBC Database",
"ODBC;DSN=fdr1;UID=hoant;PWD=hoant;Database=Oracle", acTable,
Source:="PRB_BASIN_HEADER", Destination:="PRB_BASIN_HEADER",
StructureOnly:=False, StoreLogin:=True

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

>I am using MS Access 2003. When using transferdatabase function to export
> tables in an access database to Oracle. I get an error message sayin "type
[quoted text clipped - 8 lines]
> Can you help me to locate the mismatch type or if you have a working
> example. Please allow me to share.

Reply to this Message

tthoang - 30 Apr 2007 01:16 GMT

I cut and paste your suggested code into my code. I still get the same error:
"Type Mismatch". Any idear ???

> Try removing the Source=, Destination=, Structure= and StoreLogin= bits from
> your code (and take the boolean values out of the quotes):
[quoted text clipped - 23 lines]
> > Can you help me to locate the mismatch type or if you have a working
> > example. Please allow me to share.

Reply to this Message