I am linking an Excel table to Access and one of the columns contains both numbers (e.g. 93500) and text data (e.g. P934a30). See images. My problem is that the link is set up successfully but Access considers the problem column to be numeric and displays $Num! for the text values. I cannot change the field type in Access. I have changed the Excel column format to Text but that does not help. I have seen this before so I suspect it is a common issue that I just do not know the answer for. My reason for doing a link is that the Excel tables will be updated periodically and this seems the easiest way. Can anyone offer any suggestions?
9.6 KB Views: 39
12.9 KB Views: 52