Issues with decimals when importing data from Access to SQL Server (Microsoft)

[unixhd]

I have been having issues with this for a while. For example : I want to import the number 5.21 from an access text box to the SQL server. But everytime I try it converts the number to the closest value of it without the dot. (5.6 > 6)
This is my SQL config at the moment:

I have tried float,bigint,decimal,numeric for the field m4_width.


This is my Access:

I have tried to use General Number, fixed, no format and standart. I also have tried using 1,2 and none decimal places but with no avail.

[ranman256]

make sure your access import field is set to SINGLE or double or currency,
NOT INTEGER , nor LONG as these will remove the decimal.

sql fields uses integers as SMALL INT, or INT.

[unixhd]

Tried, did not fix the issue

[Minty]

Your data in SQL is an integer data type, it can only store an integer value.
You need to use a decimal data type in SQL server.

[unixhd]

I have also tried decimal values as I said

[Minty]

You would have to change the datatype in SQL server , save the table design then re-import .
I would use Decimal (18,4) for most values unless you need a large degree of accuracy after the decimal point.

Int & Big Int definitely won't work.