By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,510 Members | 1,810 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,510 IT Pros & Developers. It's quick & easy.

How Can connect Oracle DB to Microsoft Access????

P: 1
Hi Freinds,
please, let me know if u have any idea
How Can connect Oracle DB to Microsoft Access????
i have the oracle DB but want get this tables in Microsoft Access.
Its urgent....
May 14 '07 #1
Share this Question
Share on Google+
1 Reply

P: 16
You don't want to connect to Access from Oracle.

As usual there are a heap of ways you can do this. The quickest way (assuming you are only talking about a couple of tables) is:
1. connect to Oracle, create tables to receive the data
2. connect to Oracle in Access using a linked table connecting via ODBC - WARNING: make sure Access either picks up the correct primary key or manually set this up in the linking process in the linked table or you can destroy all of your Oracle data with a single keystroke.
3. copy and paste the data from the access table into the linked table

I havent' done this for a while, there are probably a heap of utilities out there to migrate data from Access to Oracle if you have heaps of tables with integrity constraint on them.

Hope it helps.

May 14 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.