Exporting Access queries to specific Excel worksheets

  • Thread starter Thread starter a
  • Start date Start date
A

a

Hi all - how do I send the results of a query to a
specific Excel worksheet in an open Excel
workbook/template?
(coding is fine)

You can't link to a query, can you?
 
Yes you can and its easy.
From excel
data
import external data
import data
(goto the directory where the access file is then select
it)
You should see the queries then press ok

Hope I've answered your question.
 
Well, sort of. Thanks.

But I was referring to something I can automate in Access
with a code in a button's OnClick event.
 
Back
Top