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

copying table from oracle to access

P: 27
The problem: I have two schemas in an oracle database. One of the schema is the updated one. I want to update the first schema table say table A with the updated table A of schema B. The first table may have 74 rows as compared to 78 or more(for example).
I am thinking about copying the table to access and then copy it back to oracle. I may be entirely wrong, but can't think anything else. Can anyone suggest something or advise how can I do that?
I have heard about system DSN in access, but know very little about that. Any help would be great.

Aug 6 '07 #1
Share this Question
Share on Google+
3 Replies

Expert 100+
P: 1,208
You can link the Oracle tables into your Access app then run a make/update table query that will update a table in Access. Or if you have read/write permissions to the oracle database you can just make your changes in access and they will take effect in oracle.

You will have to make sure you have ODBC Database driveres installed. You can find these in your control panal....administrative tools.... Data Sources. You might have to establish a connection with a name and password. If you don't have one you might have to contact the admin.

Then in Access you go to File - get extrenal data- select the Files of types drop down and select ODBC and then go to your Oracle database and import which ever tables you need.

this is one way you can do it, but im sure someone else knows a better way. If you need anything else let me know, of if you get confusted.
Aug 6 '07 #2

P: 27
sweet !!!
worked perfectly, Thanks a lot.
Aug 6 '07 #3

Expert 100+
P: 1,208
No problem glad i could help! :)
Aug 6 '07 #4

Post your reply

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