Creating and populating an excel sheet from SQL t

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

Creating and populating an excel sheet from SQL t

Author

Topic

s.baranwal
Starting Member

4 Posts

Posted - 2008-12-19 : 01:53:14

Hi All,

How can i generate and populate an excel sheet alongwith relevent data from the SQL table?
Please suggest me the proper SQL script for this.

Thanks in advance.

Cheers,
Sanju

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2008-12-19 : 02:29:43

You can use DTS for this which is very easy.

right click on the dataasbe...tasks...export..
there select the destination as excel.

Arnav
Even you learn 1%, Learn it with 100% confidence.

s.baranwal
Starting Member

4 Posts

Posted - 2008-12-19 : 03:19:02

Actually i am new for SQL server.I dont have too much idea about DTS.
As per my query i need to generate the excel sheet with the desired data from the database table.I dont have to transfer all the data from the table.

I think, for this i need write a sql script.Please suggest.

quote:
Originally posted by sunsanvin

You can use DTS for this which is very easy.

right click on the dataasbe...tasks...export..
there select the destination as excel.

Arnav
Even you learn 1%, Learn it with 100% confidence.

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-19 : 04:09:48

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

E 12°55'05.63"
N 56°04'39.26"

s.baranwal
Starting Member

4 Posts

Posted - 2008-12-19 : 08:18:02

Thanks for your response.

I have gone through the solution provided by you.

If i am not wrong then solution no 4 is the right one for my query.
But i am not sure that how it will generate the excel sheet and import the desired data from the database table and one more thing i dont want to import all the data from the table and i want to import different data from the several table.

Please suggest and tell me all the steps in breif.

quote:
Originally posted by Peso

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=49926

E 12°55'05.63"
N 56°04'39.26"

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2008-12-19 : 08:19:41

No, it cannot generate a new Excel file for you.
It can only export to an existing file.

E 12°55'05.63"
N 56°04'39.26"

s.baranwal
Starting Member

4 Posts

Posted - 2008-12-19 : 09:01:46

Then which one is feasible for my query?
Is it possible or not? If yes,how?

Please suggest.

Thanks for supporting.

Please suggest

quote:
Originally posted by Peso

No, it cannot generate a new Excel file for you.
It can only export to an existing file.

E 12°55'05.63"
N 56°04'39.26"

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2008-12-24 : 04:10:47

quote:
Originally posted by Peso

No, it cannot generate a new Excel file for you.
It can only export to an existing file.

E 12°55'05.63"
N 56°04'39.26"

It can. I already edited the thread. See all the five points

Madhivanan

Failing to plan is Planning to fail

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources