Wednesday, June 17, 2020

Buggish: Pasting data from SSMS to Teams Excel (Web)


When I copy data from SSMS default results table to Teams Excel (Web), data is not translated directly into separate cells.


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.


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).


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