Export MS Access tables to Oracle via a macro?

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

Guest

Is it possible to setup a Macro in MSAccess that will export tables to an
Oracle Database?
 
Check the TransferDatabase Macro action where you can export Access Table to
an ODBC database. You can set up a ODBC DSN pointing to your Oracle
database if you have the Oracle ODBC driver on your PC.
 
hi,

i have used the Macro (TransferDatabase) given by you....and i have
exported the table from MSAccess 2000 to oracle....Now i am facing a new
problem.....when i type DESC EXPORTEDTABLENAME there in oracle ,i am
getting a error message like "Table or view doesn't exists'.....But when i
import that Exported table again into my access ,it imports
correctly(Including structure and values)....Can you help me out of this
situation..Thanks in advance for any help

With Best Regards

Sunil

(mail id : (e-mail address removed))
 
Back
Top