If you mean the Import/Export wizard:
Text for Export/Import from/to Excel is limited to max. 255 characters.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
Need to export from SQL server database to Excel. Data type is ntext and contains rich text. I need the data from each record to maintain within one Excel cell and preserve the rich text, i.e. line breaks and formatting.
If you mean the Import/Export wizard:
Text for Export/Import from/to Excel is limited to max. 255 characters.
The simplest way to do this is do this from Excel. Select the Data tab in the Ribbon, and then Get Data which is the left-most alternative in recent versions or Excel. Then you should be able to find your way.
The issue with the line breaks in SSMS depends on the version of SSMS and in modern versions of SSMS a setting - which defaults to retain line breaks, as I recall. You can get the most recent version of SSMS here: https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.
The setting is under Tools->Options->Query Results->Results to grid.
But it is a lot better to drive the import from Excel. If you copy and paste, Excel may "get ideas".