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
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
