transferdatabase

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
I cut and paste your suggested code into my code. I still get the same error:
"Type Mismatch". Any idear ???
 
Back
Top