Exporting a Query to Excel

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
 
R

Roger

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

Guest

hi,
write a macro, use the transfer spreadsheet method.
see transfer spreadsheet in help
 
Top