Export MS Access tables to Oracle via a macro?

S

Simon

Is it possible to setup a Macro in MSAccess that will export tables to an
Oracle Database?
 
V

Van T. Dinh

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.
 
S

Sunil

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))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Linking Access and Oracle Database 2
Macro to copy table of contents to a new doc 0
Access Database Export trying to convert into Oracle 0
oracle fields exceed 255 3
problem in exporting table from MSAccess to Oracle.... 3
Problem in exporting MsAccess database to Oracle....How can i expo 0
Using VBA to change Crystal Reports settings from Oracle to SQL 0
Access 2007 ODBC for Oracle linked table issue 1

Top