Solutions Through Learning
Callback
Sign in
Basket
Call us on 0207 987 3777 or Search our website
Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel Access
Resolved · High Priority · Version 2002/XP
Craig has attended:
Excel VBA Advanced course
Access VBA course
Hi,
I current have a front end screen built in Excel that sends data to an access database via VBA.
If I was to write a query in access how is the best way to execute the query and then send the data back to excel. I don't want to do this via the access link in excel as the data is not to be stored in the spreadsheet due to multiple user access.
Kind regards,
Craig
Hi Craig
I am sorry that we have not been able to get back to you as soon as we would have liked. We will be in touch shortly to progress your question.
Thank you for your patience.
Kind regards,
Andrew
Hi Craig, thanks for your query. If you create a linked spreadsheet in your Access database and output the results of your query to that spreadsheet table (using, say, an Append query), the results should be available in the spreadsheet via Excel. This shouldn't affect what you've already built in Excel.
Hope this helps,
Anthony
Tue 8 Feb 2011: Automatically marked as resolved.
|
|
Excel tip:Get back to active cellIf you have scrolled away from the active celland want to get back t it quicly you can Ctrl and Backspace to get back |
TrustScore
4.8
/ 5
2236 reviews
Connect with us:
We will call you back
Call for assistance
Formerly Best Training
© 2024 STL. All Rights Reserved.
All prices offered for business users and exclude VAT. E&OE
2nd Floor, CA House, 1 Northey Street, Limehouse Basin, London, E14 8BT. United Kingdom
We'll call during UK business hours
Server loaded in 0.08 secs.
