PDA

View Full Version : Solved: Datatype mismatch, Precision too small


Imdabaum
07-06-2010, 08:56 AM
I have a table in SQL Server with several fields as Numeric(10,4).

When I link this table into Access it says these fields are currency. This puts some unwanted limitations on the data I am trying to import.

Anyone ever had this issue?
Imdabaum
07-09-2010, 02:07 PM
Was anyone else aware that Numeric(10,4) was the same thing as a smallmoney type in SQL Server? That seemed to be the problem. All is well. Just made them Numeric(12,4) instead.

http://www.enterprisedb.com/documentation/datatype.html