Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cutting and Pasting in Excel Rev. Munchkindad Excel Discussion (Misc queries) 19 September 5th 07 08:40 PM
can excel auto correct when cutting and pasting bsmile29 Excel Discussion (Misc queries) 5 June 21st 06 09:06 PM
cutting and pasting rows from one sheet to another generates error JT Spitz Excel Discussion (Misc queries) 7 February 14th 06 07:06 PM
Formats when cutting and pasting Kayle Z Excel Discussion (Misc queries) 1 February 9th 06 03:57 AM
Problem encountered when cutting and pasting limws1 Excel Discussion (Misc queries) 2 July 18th 05 10:45 AM


All times are GMT +1. The time now is 10:56 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"