If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Linking an Excel file to Acces database

Hi,

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?