Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Excel Access
|
|
|
The UK's most regular Training information: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel Access
Resolved · High Priority · Version 2002/XP
Reply Tue 25 Jan 2011, 14:53Delegate Craig said...
Craig has attended:
Excel VBA Advanced course
Access VBA course
Excel Access
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
For upcoming training course dates see: Pricing & availability
RE: Excel Access
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
RE: Excel Access
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.
|