💻 Software
Copy/Pasting data from SQL Server to Excel splits up text into multiple columns?
Fresh5 days ago
Mar 15, 2026184803 viewsConfidence Score0%
0%
Problem
I've got a problem pasting data from the result grid of SQL Server 2005 to an Excel 2007 spreadsheet. I have a query in SQL Server that returns 2 columns (a number column and a text column). On one computer I can happily copy (right-click > copy) and then just right-click and paste into an Excel sp…
Error Output
Paste me please
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Copy/Pasting data from SQL Server to Excel splits up text into multiple columns?
Low Risk
If you've used Text to columns recently, it will apply those settings to the Paste operation. I don't remember this happening before Excel 2007, but it may have. I always have to go back and set it back to tab delimited before I start copying and pa…
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix