Hi,

I've a problem with converting an Acces report to Excel. I'm using VBA. I'm already so far that I can transfer the data from the Access report to Excel. But the Access report contains also groupings and groupheaders. How can I can transfer the data from Access to Excel under the same groupings?

Many thanks for your help.

Timothy

Why would you want to do that? You could export the query which the report was based on to Excel and use a pivot table to turn columns into rows.

Because what you're asking is not easy.

Thank you for your suggestion! I've never worked with pivot tables, but I will give it a try.