Export query results to Excel

[Duncan via AccessMonster.com]

Hi,

Is it possible to export the results of a query to a particular cell (say D10)
in excel instead of the default A1 cell?

Thanks in advance.

Regards,
Duncan.

 

[Tom van Stiphout]

On Mon, 12 Jan 2009 11:16:28 GMT, "Duncan via AccessMonster.com"

Not using the built-in DoCmd.TransferSpreadsheet.
If you really need to do this, use Automation. Search for
CreateObject("Excel.Application") to get started, or for "access
export recordset to excel".

-Tom.
Microsoft Access MVP

 

[Duncan via AccessMonster.com]

Thank you, Tom!

Got the solution I needed. I require a resolution to another problem I am
facing which is related to the one I posted earlier.

We have a lot of reports that get done in Excel. Our client has given us
certain templates in Excel to prepare our reports. I have written queries in
Access to extract the data. But my problem is that I need to manually copy
and paste each row of data into the template as the data points in the
template are spread out. Is it possible to programmatically choose each row
of extracted data and paste it into the template.

I do not have the option of modifying the template or creating additional
worksheets to link the template to.

Thank you in advance. Any help I can get in this regard would be greatly
appreciated.

Not using the built-in DoCmd.TransferSpreadsheet.
If you really need to do this, use Automation. Search for
CreateObject("Excel.Application") to get started, or for "access
export recordset to excel".

-Tom.
Microsoft Access MVP

Hi,

[quoted text clipped - 5 lines]

Regards,
Duncan.

 

[Ken Snell \(MVP\)]

See these articles:

Write Data From a Recordset into an EXCEL Worksheet using Automation
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#WriteRstFile

Using the Range Argument of TransferSpreadsheet when Exporting Data to an
EXCEL File
http://www.accessmvp.com/KDSnell/EXCEL_ImpExp.htm#ExpRange