Results 1 to 2 of 2
  1. #1
    james500 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Jul 2013
    Posts
    2

    Pull value from one cell into another cell in another table

    Hi, I have a "linked" table, one which is linked to an Excel spreadsheet. I need to pull certain values from this spreadsheet and automatically update, but I don't want to copy over an entire field or anything, because the values don't "line up" perfectly from the linked table to my database tables.



    In short, I want a function that is the equivalent of =a1 or =c5 or whatever, but I need it to automatically update (in case the cell a1 is changed to a new value), and I need this function to work in my Access database while the cells it pulls the data FROM are in a linked table (linked to the Excel sheet).

    How can I do this?

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    You want to update a record in an Access table with data from Excel spreadsheet. Need a unique ID shared by both data sources to identify the record to update and the record to pull from so they can be joined in an UPDATE sql action. Review http://stackoverflow.com/questions/2...ing-sql-server
    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.

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

Similar Threads

  1. Replies: 12
    Last Post: 01-15-2013, 02:35 PM
  2. Replies: 2
    Last Post: 11-29-2011, 05:26 PM
  3. Replies: 1
    Last Post: 09-11-2011, 06:14 PM
  4. paste a table into a cell
    By georgenet in forum Import/Export Data
    Replies: 3
    Last Post: 05-20-2011, 01:53 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