MS Access query to MS Excel Template

[hect1c]

Hi All,

A light bulb just came on in my head as I am struggling to come to terms with the limited functionality of Access Reports. I know using VBA would help a lot, but looking for quick fixes rather than diving into VBA just yet.

I was thinking of exporting a query to an Ms Excel template(setup all pretty) and have this in some way automated from Ms Access.

Has this ever been done and does it sound like a suitable option?

Thank you!

[June7]

Can export to Excel, not sure how template influences the process, probably no difference.

Ken Snell is a good reference for Excel export http://www.accessmvp.com/KDSnell/EXCEL_Export.htm

[NTC]

limited functionality of Access Reports?? ....

an Excel Template can link to an Access database to be its record source. The role of Access in this case is very muted in just being the query/table record source. One works from the Excel side to set up the Template and do the linking.

this arrangement is entirely different than an Access export to excel - which outputs a grid of data from Access to excel as a standalone new file....

[ranman256]

If you have the template, access can open the template, then paste the data in the cell range you want via
copyfromrecordset.

[June7]

Like NTC, I wonder what you mean by 'limited functionality'. What are you trying to do that Access report cannot accommodate?