Post reply

Export text column to excel

  • February 4, 2015 at 7:27 am

    #297454

    Hi,

    Until SSMS 2012 I copy and paste grid view with header directly to Excel. Problem starts when I try to copy results from SSMS 2012 because text column copy with some format and spreads around sheet and not in only one cell. What do I have to do how to select text columns and how to copy them to excel. IN SSMS 2008 it all works OK.

    I will appreciate any kind of help because this issue have huge impact on my ad hoc reporting process.

  • February 4, 2015 at 7:37 am

    #1775311

    It looks like this is a known issue.

    https://connect.microsoft.com/SQLServer/feedback/details/735714

  • February 4, 2015 at 7:47 am

    #1775318

    You can use the SSMSBoost addin to export the grid results to Excel, keeping data types and formatting intact.

    -- Gianluca Sartori

  • February 5, 2015 at 12:57 am

    #1775587

    Does anyone know if this work with SQL Server 2014?

    EDIT: Just info, same thing with SSMS 2014.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply