May 29, 2002 at 2:42 am
When i import data from a excel file to a DB SQL Server, this error appears :
"Data for source column 8 ('the_field_name') is too large for the specified buffer size"
What can i do ?
Thanks ...
May 29, 2002 at 4:53 am
When you get to the point in your Import where you select the sheets to import to SQL "Select Source Tables and VIews" in the grid slide over to the Transform column and press the button, then for column 8 change datatype and size to something that should hol it. I believe if I remember correctly that it is defaulted to nvarchar 255 which may not allow for enough room for your data. Try and let me know.
"Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)
May 30, 2002 at 6:26 am
Thanks. I found how to do.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply