Exporting a Query to Excel

  • Thread starter Thread starter Phil
  • Start date Start date
P

Phil

I know in Excel 2000, we can use "Get Externel Data" from "Data" menu.

I am sure that same or similar function exist within access and Excel 95.

Have a look.

Phil
 
I have a need to export data from a query to Excel. I actually need to export
3 queries to the same Excel spreadsheet. I would need each exported query to
be on its own sheet. I would like to be able to name each sheet as well. I am
using Access 95 and Excel 95. Any help would be greatly appreciated.
 
hi,
write a macro, use the transfer spreadsheet method.
see transfer spreadsheet in help
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Query from Access 2007 to Excel 2007 4
Export to Excel 3
Exporting Data from access and appending to an existing excel sprd 3
Automating export to Excel 4
Export Records Into Existing Excel File 1
Exporting Tables/Queries 21
Export query to Excel fails 6
Access 2003 db's & problems exporting query to Excel 1

Back
Top