-
Solved: excel and access
Let me paint a picture.
I am sitting at my desk using excel. I want to get excel to open an access DB, update links to excel worksheets using the linked table manager(there are five links but I only want to update three), run two queries and paste the results in two sheets in the workbook I started out in.
To add a twist, when I use the linked table manager I want to use the Open dialog box to allow the user to browse for the files they want to update the linked table manager with.
Can this be done?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules