Tag: Data type
-
SQL Server Import Wizard cannot import fields containing more than 255 characters
I have been importing data from Excel to SQL Server using the SQL Server Import Wizard. Usually there is no problem but I have found a bug. 1. To reproduce: Try to import a column containing more than 255 characters text, optimistically set the destination datatype to nvarchar(max) and the failure options to “ignore” on…
Dr James Bayley 