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.

Hi Pavy,

I know HS to ODBC :) what is OLEDB for?


Thanks

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