Error Fix: invalid precision for decimal data type in SQL Server 2005/2008

Some time you may be greeted with the error “invalid precision for decimal data type” while exporting your SQL Server table to Microsoft Excel. The main root cause of this error is, Excel doesn’t not support Decimal precision greater than 28. If you try to export a SQL Table which has column with Decimal(29,0), you probably found this error. In this case, there is only one solution is to decrease your precision limit in SQL Server table to <=28 and you will be ok.

Reference: Ritesh Shah
http://www.sqlhub.com
Note: Microsoft Books online is a default reference of all articles but examples and explanations prepared by Ritesh Shah, founder of
http://www.SQLHub.com

Advertisements