OutPut to option in Access Macros

[AccessVB]

Hello All,

Is it possible to Output data from a query to a specific worksheet in Excel? I know you can specify the file name and the path, but i want to export data from a bunch of queries into the same excel file..Any help will be appreciated. Thanks.

 

[PHV]

With OLE Automation you may consider the CopyFromRecordset method of the Excel.Range object.

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

 

[AccessVB]

Thanks, but is there a way to do it from within macro, without going into VBA?

 

[PHV]

Sorry, I don't play with macro.