Results 1 to 4 of 4
  1. #1
    Join Date
    Apr 2003
    Location
    Philly area
    Posts
    22

    Unanswered: Access Report to excel

    Is there a way to, after an Access report has been opened, export it to excel. I know how to send a table or query results to excel. But when viewing a report, the users want to send the outputs to Excel. Right now they publish it to word, and save it as a unicode txt file, then open the txt file with excel.
    Thanks much for any help.
    RG

  2. #2
    Join Date
    Dec 2004
    Posts
    277
    you want the design of the report in excel?

    if not after viewing report you can just have it export the query that the report is based on to excel

    maybe i am getting you wrong...need more info

  3. #3
    Join Date
    Apr 2003
    Location
    Philly area
    Posts
    22
    No, the users are really just looking for the data output to excel. They want to be able to export the data from the printpreview of the report. It would be nice if i could put a command button on the report, but that's not possible.

    Is there a way to do it using a macro or function linked to a help menu item?
    RG

  4. #4
    Join Date
    Dec 2004
    Posts
    277
    create a macro that on Open or Close of the report it will export the query

Posting Permissions

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