How to get Access query into Excel template??
 

Hey Guys and Gals
I need your helps!
Basically I have a preformated excel spreadsheet template which I have to populate with information generated from an access query. Currently it is a case of printing of the query in the form of a report and populating the excel template manually, although I have been told there is a way you can get access to automatically populate the excel spreadsheet......but how????

Can anyone help please??

Thanks! :tu:

Re: How to get Access query into Excel template??
 

dont you set it up from Excel?

Don't know what version of Excel you have but on 2007 I do it via Data|From Access...

Re: How to get Access query into Excel template??
 

So data, form, what am I then confirming?
I have 2003

Re: How to get Access query into Excel template??
 

Here is one solution:

1. In the Database window in Microsoft Access, click the table, query, form, or report you want to use in Excel.
2. 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.
3. Create links to this Excel file.

Or....

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

Re: How to get Access query into Excel template??
 

When you say links what do you mean?

Re: How to get Access query into Excel template??
 

You can link data from one workbook into another. Just open both, click on the cell where you want the data to appear, type "=", then click in the cell where you want data from, then press the enter key.