Results 1 to 6 of 6
  1. #1
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146

    Access 2003.


    My reports some how got corrupted. I have a prior not up to date database that I could transfer the reports to the current database. Is there someone that could assist??

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    What assistance do you need? Use the Import/Export wizard.
    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.

  3. #3
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146
    I think that will build a new report. I want to insert an existing one.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,624
    The wizard will import whatever you select. If report exists with same name then the import will have a number suffix (ReportName1). Delete the old report, rename the import.
    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.

  5. #5
    Dal Jeanis is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2013
    Location
    Dallas TX
    Posts
    1,742
    Like June7 said, you need to import a copy of the reports. You don't need to build them from scratch. You might need to rename them or reconnect them if any of the table or field names have changed.

    First, back up your current database for safety.
    Second, make a test copy of your database.
    Third, from the test copy, do this -
    Code:
    On the External data tab, in the import and link group, 
       Click Access
    On the Get External Data dialog box, 
       Select the old file
       Click import tables, queries, etc
       Click okay
    In the Import dialog box,
       Select the reports tab
       Select the reports you want to import
       Click Okay
    All those reports will be imported
    Then test each report to see if it is working as expected.

  6. #6
    nashr1928 is offline Competent Performer
    Windows XP Access 2003
    Join Date
    Apr 2010
    Posts
    146
    Thank you Dal Jeanis. Got and is all good. Thanks so much for your help.

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

Similar Threads

  1. Replies: 6
    Last Post: 12-03-2012, 05:28 PM
  2. Replies: 2
    Last Post: 08-10-2012, 12:28 AM
  3. Export from Access 2003 to Excel 2003 - missing fields
    By Jack Sheet in forum Import/Export Data
    Replies: 1
    Last Post: 02-29-2012, 04:09 PM
  4. import excel file to access 2003 yes, access 2007 no
    By stapik in forum Import/Export Data
    Replies: 9
    Last Post: 07-27-2011, 07:09 AM
  5. Replies: 1
    Last Post: 09-06-2006, 11:48 AM

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