B
Beetle
I'm trying to export/import the results of an Access parameter query to a
particular range of cells in a pre-existing Excel worksheet. Can this be done
programatically, and if so, is it best to do it from within Access or within
Excel. I've tried several methods (DoCmd.TransferSpreadsheet, Export from the
file menu, etc.) but they just create a new worksheet or want to overwrite my
existing sheet.
So far, the only way I've been able to do it is to run a make table query in
Access to create a temporary table, then open the Excel worksheet, select the
beginning cell in the range, and go through all the steps to import the
temporary table from access (a simple 48 step process that my users won't be
able to accomplish)
I would like to automate the process, but last night was Friday night, so my
capacity to figure this out seems to be somewhat diminished right now
Any thoughts?
Thanks
(message also posted in microsoft.public.access)
particular range of cells in a pre-existing Excel worksheet. Can this be done
programatically, and if so, is it best to do it from within Access or within
Excel. I've tried several methods (DoCmd.TransferSpreadsheet, Export from the
file menu, etc.) but they just create a new worksheet or want to overwrite my
existing sheet.
So far, the only way I've been able to do it is to run a make table query in
Access to create a temporary table, then open the Excel worksheet, select the
beginning cell in the range, and go through all the steps to import the
temporary table from access (a simple 48 step process that my users won't be
able to accomplish)
I would like to automate the process, but last night was Friday night, so my
capacity to figure this out seems to be somewhat diminished right now
Any thoughts?
Thanks
(message also posted in microsoft.public.access)