I need help with exporting Access report to excel.
The problem is that I need to export my report to seperate sheets (or file).
When I export my report (it conssists of several pages in which each page has several grouping orders with headers. When I export them into excel, they all come as one continous sheet, however I need them to come out in different files or at least in one file put each report page shoud be in one sheet. For example for a report that consists of 10 pages I wand an excel spread shhet with 10 different sheets.