Exporting Report Data

[wyptaj]

I have built a database and have around 30 reports each providing different statistics from the database. Is it possible to have all 30 reports run and the data exported to a spreadsheet by a click of a button. The data is things such as number of customers who did....during a month etc. Therefore each report only has 1 line of information. I am wanting all the information to be exported to a specfic cell in a specific spreadsheet. Is this possible. Please advise.
Thanks

[This message has been edited by wyptaj (edited 07-05-2001).]

 

[Chris RR]

It seems to me that the only way to do this would be in code, and a lot of code, at that.

For each of your 30 queries, you'd need to put the results into a recordset. Then you'd need to open Excel, and using the the Cells and Range properties, do a CopyFromRecordset.

Anyone else have an idea?

 

[SunWuKung]

Could you create one big report and include the 30 as subreport? Than you would only need to export one.