Exporting a multi-page report to Excel 2

[kafraco]

This is almost exactly like the question asked in thread703-1119231.

"I have a report of clients and a list of contacts for each client etc. Each client starts on a new page of the report. I want to export this report to excel and have each page of the report (each Client) go to a new sheet in Excel."

I'm pretty sure that the solution is semi-easy, but I cannot get my mind around how to do it. Right now, I am using a parameterized report that I export, then I have to manually put the big report together out of all the smaller ones.

Does anyone have a better way to do this?

 

[BoxHead]

Don't know how to do it from a report, but using a recordset will work.

Look at thread701-1198915

HTH



When Galileo theorized that Aristotle's view of the Universe contained errors, he was labeled a fool.
It wasn't until he proved it that he was called dangerous.

 

[VicRauch]

I just got done putting out over 90 worksheets in one workbook. I did not find a way within Access except to copy all the records in a query, then paste them into Excel. But Excel has a method to copy from an Access object, table or query, starting at a specific address within the Workbook. That address would be a sheet name and cell address.

This is a copy of the top of the help page for this method. You can look up this method in Excel Help for the rest of the information.

CopyFromRecordset Method

Copies the contents of an ADO or DAO Recordset object onto a worksheet, beginning at the upper-left corner of the specified range. If the Recordset object contains fields with OLE objects in them, this method fails.