How to get Access query into Excel template??

[pop80_uk]

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!

[Acathla]

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...

[pop80_uk]

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

[TheNorm]

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

[pop80_uk]

Originally Posted by TheNorm

Create links to this Excel file.
Or....

When you say links what do you mean?

[TheNorm]

Originally Posted by pop80_uk

When you say links what do you mean?

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.