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

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
problem in exporting table from MSAccess to Oracle.... 3
Can't get real oracle error with Access error 3155 0
oracle fields exceed 255 3
Creating a "create table" script for an Oracle DB 1
Exporting using Oracle date format 1
Can I import table from oracle to MS access by Transfertext? 4
Access 2007 ODBC for Oracle linked table issue 0

Back
Top