Linking Access and Excel for spreadsheet report

[CMDennis]

I wrote a database that keeps track of all corporate expenditures (capital and expense) and will track them by month until 2008. My problem is that I would like to report the data in a spreadsheet format. I have 6 different queries that generate data. I need to have those queries "feed" a spreadsheet, but the spreadsheet needs to keep the same format (headings, formulas, spacing, etc.) and the spreadsheet needs to update along with the database. I am using Access 2k. Is this possible, or am I just out of luck???
Thanks in advance.

-Chris

 

[DougP]

What do you need Excel for.

I aquired an Excel '95 sheet that was linked to Access '95 database using DDE link I hated it and how slow it was.
you have to be a master at VBA
yes it is possible but it is not for the faint at heart

I wish I could have designed it myself and just used Access.
Both are part of the "Office Suite" and both have VBA but they are two different animals.
And Access will do 99% of what Excel can do. But you have to bend Access a little. It can not act like a Spread sheet where you just key in a formula in a cell and so on.

But Access is better when you have to keep track of month after month of data and you get tired of moving and adding cells.

DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive