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
 export to excel with specific cell

Author  Topic 

nehj76
Starting Member

15 Posts

Posted - 2007-06-29 : 15:03:54
Hi, i am trying to export data in excel from SQL Server..
Is there a way to write the result in a specific cell?

For example..
select col1,col2,col3 from table1

i want to write col1 into cell B2,col2 into cell B7, col3 to C2 etc..

Pls help.
Thanks

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-29 : 23:46:05
Somewhere in this thread you can find it
http://sqlteam.com/forums/topic.asp?TOPIC_ID=49926

Madhivanan

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

jezemine
Master Smack Fu Yak Hacker

2886 Posts

Posted - 2007-06-30 : 00:38:00
hehe.

that's sort of like saying "somewhere on the internet you can find it"


elsasoft.org
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2007-06-30 : 01:05:29
quote:
Originally posted by jezemine

hehe.

that's sort of like saying "somewhere on the internet you can find it"


elsasoft.org

Yes. But I narrowed down the search

Madhivanan

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

- Advertisement -