Home Forums SQL Server 2005 Business Intelligence Excel source having more than 255 characters RE: Excel source having more than 255 characters
WayneS
SSC Guru
Points: 95409
More actions
February 5, 2010 at 10:57 am
#1114633
by default, excel text fields have a max length of 255 when importing. If using larger than this, you'll need to set up that field as a memo and not a text.
WayneMicrosoft Certified Master: SQL Server 2008Author - SQL Server T-SQL Recipes