Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Copy/Past errors

Author  Topic 

fengfeng
Yak Posting Veteran

64 Posts

Posted - 2010-03-26 : 15:43:32
I run a query with the results to text and tab delimited so that when I copy and paste into excel I get the results by column but when I copy sometimes I get it in 1 cell and where there is suppose to be a tab there is a ? with a box around it

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-03-26 : 15:44:48
Why don't you instead use bcp or DTS/SSIS which can create an Excel file correctly?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

fengfeng
Yak Posting Veteran

64 Posts

Posted - 2010-03-26 : 15:50:13
because the file I want to copy the data into already has a report on it that is not from SQL
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-29 : 02:30:53
Copy data with Results to Grid mode

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -