I had a simular issue with a direct link between excel and access.
Access does not like importing information from some forumlas.
I found a way around it by creating a new worksheet in the spreadsheet titled IMPORT DATA and then just set up =A2 (or the cell reference of the information in the...