I am currently stuggling with the same problem as emattson, and searching other helpsites it was recommended to order my fields so that text would appear at the top, hence Access recognising and allocating text as the data type.
In my case, the linked Excel table (which is replaced with a new...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.