Results 1 to 3 of 3
  1. #1
    Steve723 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2020
    Posts
    2

    Table update

    Hi all,

    I'm new on here and a complete Access newbie.

    I wonder if anyone can help me?

    I Have a data base that I need to regularly update, I do this by importing a Excel file into the current Data table (see attached image)



    I would ideally like only to update the selected columns (higlighted in yellow) rather than the whole table, I've tried the append method but this does not work for me?

    Any help would be much appreciated Click image for larger version. 

Name:	Access.PNG 
Views:	13 
Size:	54.4 KB 
ID:	40994

    Many thanks

    Steve

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    save the XL to the same place everytime: c:\temp\ImportXL.xlsx
    then link it as an external table. (done only once)
    create an append (and/or update) query to do the import (and update).
    then you just:

    1. save new XL file to c:\temp\ImportXL.xlsx
    2. run a macro that runs both : import query and/or update query
    done.

  3. #3
    Steve723 is offline Novice
    Windows 10 Access 2013 64bit
    Join Date
    Feb 2020
    Posts
    2
    Thanks ranman256, I'll give this a go and let you know how it works out

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

Similar Threads

  1. UPDATE 3073 error trying to update a table field
    By GraeagleBill in forum Programming
    Replies: 2
    Last Post: 10-11-2018, 05:11 PM
  2. Update Table after Record Update with Form
    By speciman_A in forum Forms
    Replies: 25
    Last Post: 10-31-2014, 01:00 PM
  3. Replies: 7
    Last Post: 09-21-2012, 11:09 AM
  4. Replies: 1
    Last Post: 02-08-2012, 04:50 PM
  5. Replies: 1
    Last Post: 01-22-2011, 12:23 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