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.
 
C

cw1255

Joined
Feb 7, 2013
Messages
1
Reaction score
0
I had the same problem. I created a report with the columns I wanted. Then I exported the report results to excel.
 

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 1
Copying a table from Word 5
How to Keep Excel Sheet Formatting On a CSV Sheet with vba 1
Newlines in csv files 3
How to Get Filtered Data from SQL server into Microsoft Excel 2007 5
How to put a SQL query in a single Excel cell? 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Pasting an sql from notepad to a single cell in Excel 2

Top