Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have an Access database with a table with a unique key and price field among other fields. I have been told I have access to an Oracle database with those prices in it and the linking Key.

Can I run an update query in Access to update those price fields with values in the Oracle table or do I need to import the Oracle table into Access first and then run the update query from that access table?

I'm pretty well up on Access but have never had to link it with another SQL database system.

share|improve this question

1 Answer 1

It's been a long, LONG time since I did any Access development, but if Access still supports linked tables, you can.

In that case the linked table is really just a view (select * from some_schema.some_table_in_oracle) and you can write an Access query that you use to update the Access table using the linked Oracle table.

share|improve this answer
    
Thanks. I've sorted it now by using ODBC to link them. Like you, it has been such a long time since I played around with Access that I'd forgotten how to do things like this. –  Wheelz Jun 20 '13 at 12:44

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.