Excel formats Date different after export from SSMS

Question

When I want export the result set of a sql query from Management Studio to Excel, Excel does some inconsistent formatting to column with datetime values.

IN SSMS the Date looks like that in the first picture, and after exporting the values to Excel some rows are formatted different, like in the second picture.

I only have this problem with Excel, (Tools like Libre Office don´t have this issue), but on the system which I am working on, I am not allowed to install libre office. Any advice from an Excel pro?!

EDIT: SSMS is installed in German and Excel in English (thanks to my client), EDIT2: changed language settings, no effect

Thank you

Check your language settings in ssms and excel and make sure they match — Tom
– Tom, Commented Feb 18, 2016 at 9:17

Andrei Rantsevich · Accepted Answer · 2016-02-26 17:23:20Z

1

This happens, because data is exported as text, data types are ommited. I develop SSMSBoost add-in. Alond many other tools it allows to copy-paste data to excel preserving datatypes. You can also script grid as .XML spreadsheet, which also preserves datatypes.

Hope this helps.

answered Feb 26, 2016 at 17:23

Andrei Rantsevich

2,97523 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Excel formats Date different after export from SSMS

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related