Problem Cutting and Pasting from SQL Table to Excel Sheet

  • Thread starter Thread starter Chaplain Doug
  • Start date Start date
C

Chaplain Doug

Excel 2003 Professional. SQL Server 2005.

I have a table in SQL that has five fields. One of the fields contains
multiline text information, with line breaks. When I "Select All" recods
from the SQL table, copy, and then paste into an Excel sheet, instead of the
multiline field being put into a single cell in the Excel sheet, it is broken
into multiple cells whereever the line breaks are. How can I make the paste
appear in Excel tha same way it appears in the SQL table? I want each SQL
record to be a single Excel row and the multiline fileds to be placed into a
single cell in a single row with line breaks intact. For heaven's sake, even
Word works this way. Why doesn't Excel? Thanks for the help.
 
I had the same problem. I created a report with the columns I wanted. Then I exported the report results to excel.
 
Back
Top