Hi,
Does anyone know how to link an excel spreadsheet to an access query so that the worksheet is updated each time the query is run?
Thanks.
Hi,
Does anyone know how to link an excel spreadsheet to an access query so that the worksheet is updated each time the query is run?
Thanks.
Your post does not comply with Rule 5 of our Forum RULES. We have Seven question forums: Miscellaneous, General, Programming, Worksheet Functions, Charting, Excel 2007 Help and New Users. Please choose the appropriate forum, and post your question in ONLY one forum.
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
Check out the get external data option from the Excel Data menu
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Hi RoyUK,
I tried doing that, but it did not yield the results I needed of it or maybe I am not aware of the correct way to use the external data link. what I need is something that will automatically sync data with an access query when the .xls file is opened.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks