Results 1 to 6 of 6
  1. #1
    Mohibullah is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    25

    Merging a Linked Excel sheet in Access with an in-house one

    Hi everyone,



    I was wondering if there was a way to take two columns on a linked excel sheet in Access, and merge them with an in-house or SQL linked table in Access that has those two columns as well? The purpose is so that I can take the two columns in the linked excel sheet, and have them updating to the in-house access table where I can add data associated with them, then export it. To give some context, the linked excel sheet in my access DB is an automated data dump that occurs daily.

    Thanks

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    Create an append query. Add the 2 columns in.

  3. #3
    Mohibullah is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    25
    Quote Originally Posted by ranman256 View Post
    Create an append query. Add the 2 columns in.
    Awesome, but how do I make it overwrite matching existing data, and then fill in new data? Basically I want it to match up properly

  4. #4
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    It would be an update query, wouldn't it? You would find the right records in your table thru linking and update them with the data on the Excel. The term you are using, "merging", is confusing us! That is not Access-speak.

  5. #5
    Mohibullah is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Oct 2016
    Posts
    25
    Update queries don't work from linked Excel sheets in Access.

  6. #6
    aytee111 is offline Competent At Times
    Windows 7 32bit Access 2013 32bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Please provide more details. Are you saying you can't use linked Excel tables in a query?

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

Similar Threads

  1. Replies: 2
    Last Post: 12-10-2015, 09:24 AM
  2. Deleting Linked Excel sheet
    By BatmanMR287 in forum Access
    Replies: 4
    Last Post: 08-07-2015, 12:28 PM
  3. Replies: 1
    Last Post: 03-06-2013, 10:43 AM
  4. Replies: 26
    Last Post: 01-08-2013, 04:55 PM
  5. Replies: 0
    Last Post: 02-21-2008, 09:52 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