Results 1 to 2 of 2
  1. #1

    Exporting an Access Report into Excel

    Anyone know how to import an access report (or a csv or text file) into Excel, and keep the same format? I am somewhat program literate - I can do simple macros in VBA, but this has me stumped! I can import a table or query with no problems, but the report is giving me problems. I would greatly appreciate any help. Thanks!

  2. #2
    Plutonium Lounger
    Join Date
    Dec 2000
    Sacramento, California, USA
    Thanked 1 Time in 1 Post

    Re: Exporting an Access Report into Excel

    The simple answer is, you can't. The publish to Excel link in Access is lousy, if you'll excuse the expression. I suspect the problem is caused by the nature of the report generator. So if you want to get data into Excel, export the query from Access and forget about the report.

Posting Permissions

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