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?