exporting access query into excel template

  • Thread starter Thread starter lylahk
  • Start date Start date
L

lylahk

I'm wanting to export an access query into an excel format
template. Is this possible??

Please make my life easier!!

Lylahk
 
If anyone could provide a solution to this problem below,
I have a similar issue and would appreciate some
assistance. If there is not a reasonably efficient way to
export to an excel template, is there a way to better
control the export format without writing a week's worth
of code? The limited formatting that one can do in the
datasheet/recordset view is insufficient.

I will rework all of my Excel macros, if required, but it
seems like there should be a better way. :)

TIA,
Russ
 
Hi Lylahk,

It doesn't seem to be possible to do this using the standard export or
"analyze it" routines. Instead, you need to use Automation to create a
workbook from the Excel template and insert the data from the query. The
following links should help you get started.

Sample Excel automation
http://www.mvps.org/access/modules/mdl0006.htm

Q123859 ACC: Sample OLE Automation for MS Word and MS Excel
http://support.microsoft.com/?id=123859

ACC2000: Using Automation to Create and Manipulate an Excel Workbook
(Q210148) http://support.microsoft.com/?id=210148

ACC: Using Automation to Create and Manipulate an Excel Workbook
(Q142476)
http://support.microsoft.com/?id=142476

There's also a white paper and code samples including tutorials
available from Microsoft at
http://support.microsoft.com/?id=253235



Also, search www.mvps.org/access
 
Back
Top