Output query to template

[Dan]

Hi,

I am trying to ouput a query's output into an excel
template but Outputto doesn't have for using templates
for excel. Is there another way to output the query's
output into a template?


Thanks.

 

[Pizano]

To create a query's output into an excel template, it
requires a few steps to follow:

1. Open your Access Database
2. High-light the query that you want the information onto
an excel template
3. Click on FILE->EXPORT
4. A window will appear. Select the destination of the
file where you want to store it. At the bottom of the same
window, click on the arrow and change "Microsoft Access"
to "Microsoft Excel 97-2002" and click Export.
5. After you have the excel worksheet with the data, you
can save it as a workbook, or save it as a template.
6. To save as a template, click FILE->SAVE AS
7. At the bottow of the window where it says "Microsoft
Excel Workbook", change it to "Template" and you should
now have your output from the query into an Excel
template. Hope this is what you're looking for.

 

[PIZANO]

To create a query's output into an excel template, it
requires a few steps to follow:

1. Open your Access Database
2. High-light the query that you want the information onto
an excel template
3. Click on FILE->EXPORT
4. A window will appear. Select the destination of the
file where you want to store it. At the bottom of the same
window, click on the arrow and change "Microsoft Access"
to "Microsoft Excel 97-2002" and click Export.
5. After you have the excel worksheet with the data, you
can save it as a workbook, or save it as a template.
6. To save as a template, click FILE->SAVE AS
7. At the bottow of the window where it says "Microsoft
Excel Workbook", change it to "Template" and you should
now have your output from the query into an Excel
template. Hope this is what you're looking for.