Hello,

I am importing Excel data into a SQL Server database, and one of the fields is giving me an error stating that the field is trying to accept a value beyond the 8000 character range. I know that the data is no more than 1200 characters; I think it's because there is junk data in there. Does anybody know what might be causing this? Has anyone else encountered this with excel. We are talking A LOT of files, so I can't convert it to CSV...

Brian

__________________
Brian

What is the excel field data type you are exporting from excel and what is the data type for the column in your SQL table?

Jaime E. Maccou
Applications Analyst

Brian,

Is that you are talking about "maximum row size" as your subject states, or this pertains to just one field? Coz, the max row size is 8060, beyond which you cannot insert data for a row.

Can you post the exact error here?

Cheers!

_________________________
- Vijay G
Strive for Perfection