Export Access Query to Specific Cells in Excel Report Template

[Paul]

Hi All,

I have a query in Access that needs to be Exported to a
Report Template in Excel on a Daily basis.

Fields in my Access Query:
#% of Flagged Appts
% of Transferred Calls
Total # of Flagged Appointments

Excel File Name: ReportPackageTemplate
Sheet Name = PackgATemplate
Excel Fields:
Coloumn Name = Monday PackgATemplate.C2

Rows:

#% of Flagged Appts PackgATemplate.B6
% of Transferred Calls PackgATemplate.B7
Total # of Flagged Appointments PackgATemplate.B8

Any Ideas?

 

[[MVP] S. Clark]

If you can't perform a direct export, then the answer is VBA. Visit the
Help file for the exact syntax to use when automating Excel.

Total Visual Sourcebook has plenty of code to get you started:
http://www.fmsinc.com/products/sourcebook/index.html

--
HTH,

Steve Clark, Access MVP
FMS, Inc.
Professional Solutions Group
http://www.FMSInc.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Is your Access database too slow?
Are you ready to upgrade to SQL Server?
Contact us for optimization and/or upsizing!
http://www.FMSInc.com/consulting
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-