Excel links in Access database

[dbarnes]

I have an Excel spreadsheet linked to an Access database and would like to reference a specific cell from Excel to a field in an Access for. For example I would like to reference the computed Total row/column in Excel to a form field "totals" in Access. Can this be done?

 

[ranman256]

no, Excel no longer behaves that way in Access. Its a table now.
but you can get the index of the item (a unique identifying field value) an recall the value that way.
like: select * from xlTable where [myField] = "abc"