I'm trying to import an Excel sheet to Access and it's going pretty well. How ever the Excel sheet I want to import dosen't show any decimals (of course the decimals exists but they are not shown).
When I have imported the spread sheet to an Access table, the decimals are gone. I don't want to show them in the table or any querys or reports but I want the querys to include the decimals in calculations.
For example a figure like 28.389 in Excel gets rounded to 28.000 in my Access table. How can I get Access to not drop the decimals when importing from Excel? Does it matter if I increase the number of decimals shown in the Excel sheet before importing?
When I have imported the spread sheet to an Access table, the decimals are gone. I don't want to show them in the table or any querys or reports but I want the querys to include the decimals in calculations.
For example a figure like 28.389 in Excel gets rounded to 28.000 in my Access table. How can I get Access to not drop the decimals when importing from Excel? Does it matter if I increase the number of decimals shown in the Excel sheet before importing?