0

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.

Mat
10.3k4 gold badges44 silver badges40 bronze badges
asked Jun 10, 2013 at 7:40

1 Answer 1

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.

answered Jun 19, 2013 at 20:28
1
  • 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. Commented Jun 20, 2013 at 12:44

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.