Export Access Query into Excel Worksheet

[Amin Bardai]

How about this:

I want to export results of an MS-Access query into an existing XLS template using TransferSpreads heet method?

I can create a new XLS file but I just want to append records from my query into an existing XLS template.

[ADezii]

How about this:

I want to export results of an MS-Access query into an existing XLS template using TransferSpreads heet method?

I can create a new XLS file but I just want to append records from my query into an existing XLS template.

I think you are out of luck with TransferSpreads heet but all is not lost. You can create a Recordset based on the Query and write its contents Row by Row to an External Text File as illustrated in Post #2.

P.S. - See Post #4 in the following Link. It deals with a similar type situation.

http://bytes.com/topic/access/answers/891157-possible-pass-current-forms-recordset-docmd-

[NeoPa]

This thread was originally posted in Export records via macro and append an existing Excel file.

Please post your questions in their own thread in future.