Problem Cutting and Pasting from SQL Table to Excel Sheet

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exporting Data From Excel to SQL 2
Merging from an Excel file with graphics 1
Pasting a cell into bookmarked table from excel vba 1
Paste to excel from word - auto format problem 1
Converting excel to PDF, single page converts to multiple HELP! 1
Dealing with the error: unable to filter on excel hc home school 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Search and consolidate multiple values in multiple fields 2

Top