Recent content by Malb

I can transfer sheets into Access. The question I asked was about linked sheets and I really would like an answer to that question, if there is one. Surely Access must have some way of detecting #Num! errors? If you tell me it does not, and that Microsoft have provided no way to stop #Num...

Sorry, yes, it is an Excel table. Taking a copy would be a possibility but then I would have delete the whole table and re-read it periodically thus defeating the point of linking the data rather than importing it. Also there are a number of tables involved and it is easier to switch links and...

I have a linked table which will contain errors and which give an #NUM! error. That's fine. I can't clean up the data I'm linking to (not in my control) but I know that the #NUM! error items can just be ignored for my reporting purposes - they don't affect the totals I am trying to extract...