This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(278.4, 72%, 36%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ERB%3C/text%3E%3C/svg%3E)
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.
I need the data from each record to maintain within one Excel cell
Sorry, your post is more then unclear?
Everything of the text in one cell of a Excel worksheet???
Why Excel and not Word?
Sorry, there are other columns being exported, datetime, nvarchar, etc, and ntext. The ntext column has rich text in it. When pasting results from SSMS to Excel, the rich text column does not maintain in one cell per record, line breaks in the rich text cause Excel to go to a new line, which jumbles al the results. I have tried to do this in SSIS, but I keep getting an error no matter what I try...
[Excel Destination [2]] Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E21.
An OLE DB record is available. Source: "Microsoft Access Database Engine" Hresult: 0x80040E21 Description: "Multiple-step OLE DB operation generated errors. Check each OLE DB status value, if available. No work was done.".
[Excel Destination [2]] Error: An error occurred while setting up a binding for the "ExtNotes" column. The binding status was "DT_NTEXT".
[Excel Destination [2]] Error: Cannot create an OLE DB accessor. Verify that the column metadata is valid.
[SSIS.Pipeline] Error: Excel Destination failed the pre-execute phase and returned error code 0xC0202025.
Hi @Richard Bonnette,
Could you give same data sample and your expected result so that we can do more analysis.
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".