February 7, 2007 at 3:13 am
Hi
In Query analyzer you could just go results to text copy and past and put it into excel and all the column headers and data would be inserted properly.
The paste from 2005 inserts the query incorrectly -- puts data in wrong colums like putting colum headers in one cell. Has anyone come across this? It seems microsoft has taken something useful and made it unuseful
February 7, 2007 at 3:55 am
try export to text file and import. Never did like the cut and paste!!
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 7, 2007 at 4:09 am
I figured it out
Query->query options->grid
tick include column headers when copying or saving results
February 7, 2007 at 10:53 pm
Thanks Grasshopper
This could come in very hand.
February 8, 2007 at 1:19 am
hmm .. my post didn't publish .. I posted to say thanks and to say that I just learned something I didn't know - cheers.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
February 8, 2007 at 5:20 am
no probs
grasshopper learning to jump
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply