Export Access Query Output to Excel Workbook

[mveera]

Hi,

I would to know how to Export a Access Query Result to an Excel Workbook Template.

My requirement is to create a worksheet with the results of an Access Query. For each Query Result i will have to create separate workbooks. I was able export using Access Menu. I would like to know how i can do it programmatically.

Thanks
Veera

 

[mveera]

Thanks.

I found out how to do it using the following code

DoCmd.TransferSpreadsheet cExport,"qryName","d:\tmp\tmp.xls"

Veera

 

[mveera]

Thanks.

I found out how to do it using the following code

DoCmd.TransferSpreadsheet cExport,"qryName","d:\tmp\tmp.xls"

Veera