Exporting Access queries to specific Excel worksheets

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

John Masui

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

a

Well, sort of. Thanks.

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