View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Chaplain Doug Chaplain Doug is offline
external usenet poster
 
Posts: 127
Default Problem Cutting and Pasting from SQL Table to Excel Sheet

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.

--
Dr. Doug Pruiett
Good News Jail & Prison Ministry
www.goodnewsjail.org