Results 1 to 5 of 5
  1. #1
    guillermoftw is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    13

    Import Excel Sheet to Update Tables

    Hello all,



    Is there anyway I could import an excel spreadsheet to access to update an existing table? The table was created before and I'd like certain columns to be updated with certain rows from a spreadsheet.

    Any help would be great! Thanks.

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,900
    Import it to a new table.
    Then you can link the new table with your original table, and use an Update Query to update any columns which have changed.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  3. #3
    guillermoftw is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    13
    Joe,

    Right before I saw this, i just thought of making a new table and updating it from there haha. Thanks so much for the help though!

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,900
    Right before I saw this, i just thought of making a new table and updating it from there haha. Thanks so much for the help though!
    Well then, I hope I at least confirmed that you were on the right path!
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  5. #5
    guillermoftw is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Dec 2014
    Posts
    13
    Absolutely! You can take credit for this one haha

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

Similar Threads

  1. Replies: 10
    Last Post: 06-16-2014, 08:37 AM
  2. How would I import the excel sheet like this to Access
    By Arvine in forum Import/Export Data
    Replies: 3
    Last Post: 05-18-2014, 03:47 PM
  3. import excel sheet causes autonumber beyond records
    By BCJourney in forum Import/Export Data
    Replies: 11
    Last Post: 09-25-2013, 06:02 AM
  4. Import excel sheet data into Ms-access using VBA macros
    By gokul1242 in forum Import/Export Data
    Replies: 2
    Last Post: 10-02-2012, 04:39 AM
  5. Import Excel sheet with query
    By tpcervelo in forum Queries
    Replies: 1
    Last Post: 08-03-2010, 07:10 PM

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 - Senior Forums