You are mostly likely trying to shove a piece of data in a SQL field that isn't "wide" enough. Meaning, if you are trying to put a string that is 10 characters long into a SQL table field that only accepts strings 5 characters long (say, a varchar(5)), you will get that error. With numbers, it's a little trickier, because you have Int16, Int32, long, double, float, etc., all of which have varying lengths.
So, just make sure that the SQL database field you are trying to populate can actually hold that piece of data you are trying to put in it. You're probably going to have to alter the database table field, and "widen" it a bit to accommodate your data.
Cheers,
Patrick Pitre

Help the community by fixing grammatical or spelling errors, summarizing or clarifying the solution, and adding supporting information or resources. Always respect the original author.

You are mostly likely trying to shove a piece of data in a SQL field that isn't "wide" enough. Meaning, if you are trying to put a string that is 10 characters long into a SQL table field that only accepts strings 5 characters long (say, a varchar(5)), you will get that error. With numbers, it's a little trickier, because you have Int16, Int32, long, double, float, etc., all of which have varying lengths.

So, just make sure that the SQL database field you are trying to populate can actually hold that piece of data you are trying to put in it. You're probably going to have to alter the database table field, and "widen" it a bit to accommodate your data.

Copyright 1998-2015 Ziff Davis, LLC (Toolbox.com). All rights reserved. All product names are trademarks of their respective companies. Toolbox.com is not
affiliated with or endorsed by any company listed at this site.