hi!!
i'm trying to export a table, from access 2003, through a ODBC connection to a oracle table.
i made the connection using this code, DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=xxxx;UID=xxxx;PWD=xxxx;SERVER=xxxx", acTable, "teste".
when i execute this code appears a message box with "run time error 2507" and says that i don' have this type of ODBC databases installed.
How can i solve this?
thanks
i'm trying to export a table, from access 2003, through a ODBC connection to a oracle table.
i made the connection using this code, DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=xxxx;UID=xxxx;PWD=xxxx;SERVER=xxxx", acTable, "teste".
when i execute this code appears a message box with "run time error 2507" and says that i don' have this type of ODBC databases installed.
How can i solve this?
thanks