Having (I hope) sorted the #Num! problem in Access I find
some fields datatype is wrong. I want text but Access makes it a number
Not all fields though - and I can't see why.
Is there a method to make every cell text? I've been selecting a column, right clicking - Format Cells - Catagory - Text
Then re-linking but it's still a Number in Access.

Many thanks for a solution.

Cheers - Kirk