Hello,
I have an excel workbook that is linked to an Access table. I am able to view the table just fine through "Connections".
However, i was wondering if it were possible to update the values in Excel so that it would update the values in the Access table? When i try it, it doesn't actually update. When i refresh the connection, it just refreshes the original data from the access table.
Any ideas?
AFAIK, that connection is one-way - edits to data displayed on sheet will not pass back to Access. Would have to use VBA to make a connection to Access and edit data.
Why are you wanting to use Excel as interface to Access?
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
After much research, that is what i'm also discovering. Our users are just much more familiar with Excel and i was trying to avoid building a form for the data entry/edit.Originally Posted by June7
Looks like i'll have to go and do that. Thanks for the confirmation!
You don't have to do that. I run my home accounts from Excel, with an Access database to hold all of the transactions.
Excel gives you plenty of tools, Power Query, PowerPivot, pivot tables, SQL/ODBC. And then you can use the Excel to input the data you want to update to Excel.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
Posting Permissions
Reply With Quote
