Been looking everywhere and can't find a solution - any ideas please!?
I need to be able to extract the value from an Excel cell reference, and import that value into a specific field within an Access database.
I can link the db record to the file, thats not an issue.
MyXLFile - MySheet - Cell A1 = £654,965
....import into Access.....
Id - MyTextField - MyXLValue