Numbers/Currency im****t into Access as text

I'm im****ting & linking both numbers & currency into Access via ODBC from 
QAD's MFG/PRO system.  The problem is that the numbers & currency
im****t/link 
into Access as text, thus not usable for mathmatical calculations.  

I've been told that QAD's MFG/PRO has more positions to the right of the 
decimal place than Access will allow, thus considering the information as 
text since it won't "fit".

This is really a big problem and we're having a hard time finding a fix.