In access, right click on the query that generates your data, or the table
that contains the data and select Export. At the bottom of the Export dialog
box select the Save File As Type combo box and select the Excel flavor of
your choice. You should have Excel 3, Excel 4, Excel 5-7 and 97-2000 if
you're using Office 2000.

You could also do this running MS Query from Excel too.
--
Kevin Backmann


"Dawn" wrote:

I've got a macro in Access that runs two Append Queries to a table. I want
the resulting table to populate an Excel worksheet - can I use the Import
Data function in some way to do this? I already use it to Import some
regular query results.