Issue
When I copy data from SSMS default results table to Teams Excel (Web), data is not translated directly into separate cells.
Cause
The cause for this is due to one of the cells that starts with a single double-quote. This will result with all data after the single double-quote to be in a single cell.
Fix
I do not have a fix for this if you require to keep the double-quote except to manually work around it. This was a data issue on user end which does not resolve the actual issue.
Work-around is perhaps to save the SSMS results in a different format, replace the double-quote with a different value or prepend with an escape character (sorry, I don't know what that is either).
Setup
SQL Server Management Studio | v18.4 |
Google Chrome | Version 83.0.4103.97 (Official Build) (64-bit) |
Teams Excel (Web) | 16.0.13014.35904 |
No comments:
Post a Comment