var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Too large for the specified buffer size
I've been searching this site and the Web for info on an error message I get when importing from Access 2003 into SQL Server 2000.
'Data for Source Column 3('Col3') is too large for the specified buffer size'
A memo field in Access is larger than 255.
I have followed advice about putting the field to the first column. This doesn't work - the error just returns the new column number. In fact, I've tried just importing the first column - no good.
I am wary about making Registry changes as comments on the Web say this doesn't work either.
Does anybody have the solution for this.
Col3 is a memo field in Access? What is the datatype of the column you are importing to?
Thanks for replying. Its a text field.
What tool are you using to import the data? DTS? MS Access?
I'm running a Job in DTS SQL Server 2000. I'm linking to the Access database, and entering the data into an SQL table - at least I'm trying.
hope this helps
had this problem for a while and tried everything. In the end I changed the dts package to convert the varchar to a ntext, import data and then change field back again at the end.
This is a long time ago now, but I thing that I did something similar to what you suggest.
Thanks for taking the trouble to reply.