Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cutting and Pasting in Excel | Excel Discussion (Misc queries) | |||
can excel auto correct when cutting and pasting | Excel Discussion (Misc queries) | |||
cutting and pasting rows from one sheet to another generates error | Excel Discussion (Misc queries) | |||
Formats when cutting and pasting | Excel Discussion (Misc queries) | |||
Problem encountered when cutting and pasting | Excel Discussion (Misc queries) |