title: automatic conversion of Text into Decimal number - Access
body: <p>I am trying to import data from MS SQL Server DB into MS Access using ODBC.
  For mostly all datatypes the import is mapping types correctly, but when the SQL Server column datatype is Decimal Number, MS Access converts it to text datatype.
  So I am trying to find a proper workaround that automatically converts this Text into Decimal Number.</p>
  
  <p>E.g : 
  one price is coming in as '3978.76821' and datatype is set to text so I can't run simple calculations on the field. </p>
  
  <p><img src="https://i.stack.imgur.com/zd4mY.jpg" alt="Screenshot showing data in both SQL server and MS Access"></p>