estecher
asked on
when importing data from excel 97-2000 to sql database-I get the error "data of the source column too large for the specified buffer size"- the column has >1024 characters
I am unable to import the excel to the database how do i do that ---I have the variable as varchar 5000 in the database but still unable to import characters greater than 1024. Please give your suggestions.
ASKER
Right now i have resolved the buffer size problem but i am getting an error that says
Error at Destination for Row number 654(which is the last row).
Cannot sort a row of size 11824, which is greater thatn the allowable maximum of 8094.
Any suggestions will be appreciated.
Thanks in advance.
Error at Destination for Row number 654(which is the last row).
Cannot sort a row of size 11824, which is greater thatn the allowable maximum of 8094.
Any suggestions will be appreciated.
Thanks in advance.
ASKER
I could resolve this problem by changing the data type of my row to ntext.
ok, Hope your problem is solved.. Now can you close this question
ASKER
how do i close this question.
I don't find any button or any tool to closer.
I don't find any button or any tool to closer.
It is quite simple, you read the EE Help: That is the link on the top right corner that reads "Help".
As you may be having some difficulty with that, let me post the exact link:
Nobody answered my question. What do I do?
https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi71
As you may be having some difficulty with that, let me post the exact link:
Nobody answered my question. What do I do?
https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/help.jsp#hi71
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
http://support.microsoft.com/kb/281517/EN-US/
Cheers!