Results 1 to 3 of 3
  1. #1
    Join Date
    Apr 2004
    Bucharest, Romania

    Question Unanswered: Keep report layout when export to Excel

    Anyone know how to keep the layout when exporting a MS Access report in Excel?


  2. #2
    Join Date
    Feb 2004
    Refer to MS Excel help "Create a template to share external data". Access reports don't easily port out to Excel, but you may find that excell can import it from access. Good Luck!

  3. #3
    Join Date
    Aug 2004
    As far as I know there is no functionality that retains formatting when exporting Access reports to Excel. But you can create Excel spreadsheets from Access.

    What you can do is set up the formatting in Excel. How to do that is to start a macro recorder and build the formatting in a spreadsheet and when finished, stop the recorder and save the macro. Then you go into the macro's code, copy the VBA and paste that into an Access module, with the code to move the data to the spreadsheet. You are going to have to perform loops, count lines and use at least one recordset to move the data into the spreadsheet that way.

    Do a search for automating Excel from Access and you should find some good examples.


Posting Permissions

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