Pasting from SQL Server Management Studio to Excel concatenates columns

This is an issue with Excel.

After you paste the results into Excel, go to the “data” option and choose “Text to Columns”. Then click on “delimited” and be sure that “tab” is checked on the next window.

This will convert the data into columns. And, Excel remembers the settings, so it will paste correctly the next time.

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)