I have an excel spreadsheet with a column that is formatted to text. Some of the cells are numbers and others are alpha/number. When I link this to Access only part of the column comes in correctly. The rest of the cells say #Num! and when I look at the design it says it is set to Number...