Exporting data from Access to the specified sheet of Excel

[Jas]

I want to export some data by using Access query to the specified sheet of
the workbook.I tried to use TransferSpreadsheet method, but is it possible to
transfer output of the query to the specified sheet?

 

[Bob Larson]

You might want to use the Excel object model to do this export.

Check out the sample code here
http://www.btabdevelopment.com/main/CodeSnippets/tabid/104/Default.aspx
(look for the Export2Excel code)
you should be able to modify it to fit your needs.

--

Thanks,

Bob Larson
Access MVP
Administrator, Access World Forums
Utter Access VIP

 

[shekhar main]

I want to export some data by using Access query to the specified sheet of
the workbook.I tried to use TransferSpreadsheet method, but is it possible
to
transfer output of the query to the specified sheet?