Linking an Excel file to Acces database
I am trying to link an excel file to an Access database as a link table. All is well except that a column which holds unit cost values and is formatted as "Currency" comes accross the linked table having text property, which access does not allow me to change. I have gone back to the original excel file and re-formatted the column as curreny or numeric but still does not help. In Access it has text property
Any ideas how I can force this column to be linked having currency, numerical or accounting property?
Many thanks to anyone with help and suggestions.