Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006
    Thanked 0 Times in 0 Posts

    Exporting a report to Excel (2002)

    I have written a report in Access, and when I export it to Excel, it doesn't look anything like it. How can I export a report to Excel to look like what I have enclosed. It looks like this in the Access report, but it doesn't when I export it to Excel.

    Chris Elias

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Exporting a report to Excel (2002)

    The export feature in Access is feeble. Microsoft hasn't significantly updated it in 10 years or so. When you export to Word (RTF), Excel or HTML, only a small part of the formatting is preserved.

    One way to preserve the formatting is to export to snapshot (.snp) format - this is built in - or to PDF format - you need external software for that. Both formats are useful for displaying and printing the report on PCs that don't have Access installed. You won't be able to do anything with the data in the report.

    Another way would be to use VBA code to build a spreadsheet with the formatting you like, but that would be very tedious.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts