What are the challenges you face when working across database platforms? Take the survey

SSMS Results - Open in Excel gives Excel error


I have often with satisfaction used the 'Open in Excel' on resultsets in SSMS, but resently it has started(failing)

I have an very simple query returning an int and a decimal column, but when opening in Excel I get the showed error.

I cannot pinpoint exactly what is wrong, but after clicking 'Yes' it seems ok, but for large resultsets it can be difficult to be sure.

Do you have any suggestion as to what is going on here. It used to work flawlessly, and the function is very handy as it is the best way to get correct formatting in Excel.

Thanks in advance


Sign In or Register to comment.