how to export data from access to oracle database
i want to export data residing in access database to oracle database. please help me.
thanks in advance.
Two solutions on the top of my mind.
#1 -- Oracle side solution
Oracle Heterogeneous Services allows you to connect to whatever ODBC/OLEDB datasource, including MS-ACCESS
#2 -- MS-Access side solution
You can link from MS-Access to an Oracle database defining Oracle side tables as external tables.
Hope this helps.
Pablo (Paul) Berzukov
Author of Understanding Database Administration
available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
I know HS to ODBC what is OLEDB for?
Behind The Success And Failure Of A Man Is A Woman
Oracle Migration workbench?
thanks I mean can I use it to connect to my accessdb instead of ODBC HS ...I really confused with lots of oracle products & terminologies.
It depends on what you are going to do. If you want one time migration, Oracle Migration Workbench is your tool. If you want regular transfers, go for HS
Ah ok...as for now I am contented with HS
Click Here to Expand Forum to Full Width