Export Formatted Report from Access to Excel

[talytech]

Hi, Does anyone know a way to export an Access report with group levels to Excel and keep the layout and formatting of the report in Excel? Whenever I export my report to Excel it screws up the format. Somebody please tell me there's a way to do this. I'm praying for some answers.

[geekgirlau]

Depends on what the layout is supposed to look like, but basically the format is never going to match exactly. Can you post some examples of the Access report and the Excel version (what you get, and what you want to get)?