-
how to export data from access to oracle database
Hi all!
i want to export data residing in access database to oracle database. please help me.
thanks in advance.
Khanaekhan.
-
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.
-
Hi Pavy,
I know HS to ODBC what is OLEDB for?
Thanks
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
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|