export access query into excel template starting from specific cell

[registoni]

Hi,
I have a simple select query in access consisting of 7 fields (columns), which I need to export to a ready-excel spreadsheet starting from cell A5 in excel sheet LIST_INTERNAL in the file INTERNAL.XLX. The number of columns (7, from A to G) and order of them in Excel is the same as in Access query.


I suppose there should a simple code to do so, but as I am still a novice ACCESS user, I do not have any clue how to do it.

[June7]

Can't use TransferSpreadsheet to export to specific range (import from range, yes) so this means VBA code that opens Excel as an object then writes data to the desired range. There are several methods to accomplish populating cells.

1. Bing: Excel range copyfrom recordset
http://msdn.microsoft.com/en-us/libr.../ff839240.aspx

2. Write data to cells one at a time.
Review: http://forums.aspfree.com/microsoft-...el-413629.html