Fomating query from linked Excel

[Skip Bisconer]

I have linked some XL workbooks to my database. There is an amount column that is formated as Currency in Excel but when I look at the structure of the linked file that column comes accross as Text. My history tables all have that as fields property as Currency. When I try to append data to one of these history files I get a datatyp mismatch error and this is the only mismatch I can see between the queries and the tables. I formated the fields as currency in my queries but I still get the error. Any suggestions would be appreciated.

 

[neileg]

Formatting as currency still leave the data as text. If you convert the data to currency using the CCur() function, that should work.