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?
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.
Posting Permissions
Reply With Quote