Results 1 to 2 of 2
  1. #1
    Jakz34 is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2009
    Location
    Jonesboro, AR
    Posts
    4

    Updating Access Database With New Excel Data

    A colleague of mine has setup a very nice Access database so I can print out a list of data that share relationships. The data is first produced in Excel then is linked together using Access. She has Access setup where the relationships are already created in the file, all I have to do is add the updated data when it is produced.

    The problem I am having is adding the updated data.


    Here is the data:






    The scan audit and scn files are what is being linked in Access and the final report is what is being exported from Access once the link occurs.

    Here is how it is listed in Access:




    My colleague said something about the files needing the same name as before and the Excel files all have the same name they previously had but I am not sure if I need to import them or if Access recognizes the files are in the same folder and picks the data up from them.

    My problem is, how do I get those updated Excel files imported into the Access database to replace the old data with the new data and produce a new final report?

  2. #2
    Join Date
    Feb 2009
    Posts
    16
    Check out Tools-->Database Utilities-->Linked Table Manager (I don't think this is what you want but check it first).

    or File-->Import... and select the appropriate file.

    These things should get you started. There are plenty of help files on this as well.

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

Similar Threads

  1. Updating Data Access Page on Intranet?
    By slash75 in forum Access
    Replies: 0
    Last Post: 11-14-2008, 03:26 PM
  2. Call Excel Data into Access table
    By jiguvaidya in forum Import/Export Data
    Replies: 0
    Last Post: 09-15-2008, 04:58 AM
  3. VBA Opening Excel File and Placing Data in Cells
    By BobTHG in forum Programming
    Replies: 0
    Last Post: 01-13-2008, 03:01 PM
  4. Excel to Access
    By iturnrocks in forum Access
    Replies: 0
    Last Post: 08-02-2006, 10:10 PM
  5. Can we post Access cell data to Excel cell properties?
    By Zethro in forum Import/Export Data
    Replies: 1
    Last Post: 12-13-2005, 08:42 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