Results 1 to 2 of 2
  1. #1
    aaslezak is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2015
    Posts
    34

    Exporting a report to Excel

    I am trying to export a report to Excel but I lose a lot of the fields. I have access 2007-2010 and it will only let me convert the report to Excel 2003. I want to be able to export it to Excel 2010 or 2013 and maybe I will get better formatting because instead of putting the fields on the screen for all the labels for the footers it gives me things like Text121. Is there some way I can make this transition a little better by changing the names on the report or doing getting some down load that would allow me more choices? TIA



    Al
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    The report seems to export nicely. Don't know why it shows Text121. Do the summary textboxes have associated labels? What is label Caption set to? Is Text121 the name of textbox?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Exporting a report to Excel
    By DGBagby in forum Access
    Replies: 6
    Last Post: 03-04-2015, 01:11 PM
  2. Exporting the report to MS Excel
    By Blunty in forum Reports
    Replies: 7
    Last Post: 06-22-2012, 10:41 AM
  3. Exporting Report to Excel via Command Button
    By need_help12 in forum Import/Export Data
    Replies: 3
    Last Post: 04-24-2012, 03:27 PM
  4. Exporting report selected from a listbox to excel
    By GARCHDEA in forum Import/Export Data
    Replies: 1
    Last Post: 08-10-2010, 07:45 AM
  5. Exporting a Report to Excel
    By bullwinkle55423 in forum Reports
    Replies: 0
    Last Post: 12-11-2007, 10:27 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums