Cable Forum - View Single Post - How to get Access query into Excel template??

TheNorm · 11-11-2007, 12:59

Here is one solution:

In the Database window in Microsoft Access, click the table, query, form, or report you want to use in Excel.
On the Tools menu, point to Office Links, and then click Analyze It With MS Excel. Access saves the contents of the table, query, form, or report as a Excel workbook (.xls) file and opens the file in Excel.
Create links to this Excel file.

Or....

Have a look at this 20 minute training website: http://office.microsoft.com/training...RC011831161033

11-11-2007, 12:59	#4
TheNorm Inactive Join Date: Jun 2006 Location: Cambridge Services: Sky TV, VM TV, 20meg bb, tel, and a lobster (but the lobster died). Posts: 4,349	Re: How to get Access query into Excel template?? Here is one solution: In the Database window in Microsoft Access, click the table, query, form, or report you want to use in Excel. On the Tools menu, point to Office Links, and then click Analyze It With MS Excel. Access saves the contents of the table, query, form, or report as a Excel workbook (.xls) file and opens the file in Excel. Create links to this Excel file. Or.... Have a look at this 20 minute training website: http://office.microsoft.com/training...RC011831161033