exporting a query to a excel workbook

[sk8er1]

Its easy to export a query to a new spreadsheet file, but how can you get it into an existing worksheet...for instance a workbook tab...I would like to add it to an existing workbook with its own tab...

Thanks

 

[PHV]

Why not pulling the data from within Excel ?
menu Data -> External data -> ...

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[dmksas]

sk8er1,

If this is to be either part of an automation or a regular method then please take a look at this example

Danny

Never Think Impossible

 

[sk8er1]

I found out that you can copy the table data from access and paste it into a workbook tab.

 

[JerryKlmns]

sk8er1,

there is always a CopyFromRecordset method inside excel where you can find an example