troubleshooting Question

Export long results in SQL to Excel

Avatar of al4629740
al4629740Flag for United States of America asked on
17 Comments2 Solutions24 ViewsLast Modified:
I have a problem.  I exported 3 columns of data in a query with 1300 records but the last column is a narrative which has a lot of data in it.  Is there a way to export this clean into an excel sheet from a SQL query?

When I try to Save Results, its a real mess so that does not work.  Even if I copy and paste it into excel it still is a hot mess.
Tomas Helgi Johannsson
Database Administrator / Software Engineer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 2 Answers and 17 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 2 Answers and 17 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros