Building a spreadsheet with Access

[proben930]

Hi-
I have a bunch of numbers stored in several records in several tables. What I want to do is to pull the ones I want (I have done this via. query), and design them into something like a spread sheet that I can export somehow. I could format it just like I want in a report, but I need to be able to copy/paste the information. So.. how can I create/format something of a cross between a report and a spreadsheet? Export the data to excel and format it there? It would involve inserting text and what not. TIA!

Ben

*I know this may involve a long explanation, and if so, can you direct me to some place to read on the subject?

 

[sfreeman@co.mer]

Link It...

I would suggest that you create a spreadsheet in the format that you prefer, and then, link to it within Access as a linked table. Then you can run normal append or update queries to keep the data fresh.

If you want the spreadsheet in Access, just embed it in a form.

 

[spacepro]

Hi,

Try this link .

It basically exports data from a query and uses a template file to autofill the data by linking the query data to the worksheet that is formatted.

Take a look. This has helped me out before.

Regards

Andy