Results 1 to 2 of 2
  1. #1

    Importing 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
    3 Star Lounger
    Join Date
    Dec 2000
    New Zealand
    Thanked 0 Times in 0 Posts

    Re: Importing Access Report into Excel.

    Try doing it the other way round. Exporting from Access to Excel is easier. When you are previewing your report there should be an Excel or Word button in the toolbar. By clicking the excel button a spreadsheet version of the report will be created.

Posting Permissions

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