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

Ivan Yorkishev 1 Reputation point
2021-11-05T08:09:28.02+00:00

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.21 > 5 and 5.6 > 6)

This is my SQL config at the moment:
146750-screenshot-2021-11-05-092731.png
I have tried float,bigint,decimal,numeric for the field m4_width.

This is my Access:
146725-screenshot-2021-11-05-100618.png
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.

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,692 questions
Access Development
Access Development
Access: A family of Microsoft relational database management systems designed for ease of use.Development: The process of researching, productizing, and refining new or existing technologies.
821 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. tibor_karaszi@hotmail.com 4,301 Reputation points
    2021-11-05T08:23:07.28+00:00

    And int in SQL Server is an integer, it has no decimals. Perhaps you should use the decumal(9,2) type (or whatever you want for scale and precision)? https://learn.microsoft.com/en-us/sql/t-sql/data-types/decimal-and-numeric-transact-sql?view=sql-server-ver15