Import Limited to 255 Characters

[grnzbra]

I am trying to import an Excel spreadsheet, a few rows of which have a column with entries in excess of 300 characters. The Import and Export wizard is only passing on the first 255 characters. When I get to the window that allows changes in mapping, all the sizes are set to 255. Changing increasing the size doesn't help; it still only loads the first 255 characters into SQL Server. Is there any way to change the number of characters that are being fed into the conversion?

 

[SaltyTheFrog]

Since you don't have any responses I googled:

sql server Import and Export wizard is only passing on the first 255 characters

I got a lot of hits so it is a common issue. This link looked promising:

https://social.msdn.microsoft.com/F...n-255-characters?forum=sqlintegrationservices