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
 NEW SQL- How to export table to excel spreadsheet?

Author  Topic 

perryplyang
Starting Member

3 Posts

Posted - 2005-12-18 : 11:09:06
Hi All,

I am new to SQL program. I did little management for SQL 2000 before.
I need to export from a table or view to excel spreadsheet for company's marketing resourece. Is there any easy simple way to do it?

Thanks all for your help.

Perry Yang

afrika
Master Smack Fu Yak Hacker

2706 Posts

Posted - 2005-12-18 : 12:38:29
Use the DTS import/export facility in Enterprise manager

there are other script examples in this forum, you could do a search
Afrika
Go to Top of Page

Srinika
Master Smack Fu Yak Hacker

1378 Posts

Posted - 2005-12-18 : 16:04:58
From Excel:
Open a Excel File (blank) - Use the Data --> Get External Data --> New Database Query and follow the instructions.

From MS SQL Server:
Use Import Export Wizard or a DTS package
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-12-18 : 23:56:47
or

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

Madhivanan

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

perryplyang
Starting Member

3 Posts

Posted - 2005-12-19 : 18:28:09
Thank you for all your help.
I will take a try.

Perry Yang
Go to Top of Page

perryplyang
Starting Member

3 Posts

Posted - 2005-12-19 : 18:58:02
One more question, where can I find DTS at SQL 2005? Did MS change DTS to something else at SQL 2005?

thanks again.

Perry Yang
Go to Top of Page

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2005-12-19 : 21:14:11
Yes. DTS has been reincarnated as SQL Server Integration Services (SSIS) in SQL 2005
quote:
Integration Services

SQL Server 2005 includes a redesigned enterprise data extraction, transformation, and loading (ETL) platform, called SQL Server Integration Services (SSIS). SSIS enables organizations to more easily integrate and analyze data from multiple heterogeneous information sources. By analyzing data across an array of operational systems, organizations may gain a competitive edge through a holistic understanding of their business.
Enterprise ETL Platform

This new platform is the successor to the popular feature in SQL Server 2000 called Data Transformation Services (DTS). SSIS is completely new for SQL Server 2005. SSIS provides the breadth of features and very high-scale performance that is necessary to build enterprise-class ETL applications. SSIS is fully programmable, embeddable, and extensible—characteristics that make it an ideal ETL platform.


-----------------
[KH]

Learn something new everyday
Go to Top of Page

activecrypt
Posting Yak Master

165 Posts

Posted - 2005-12-20 : 00:14:38
hi,
may suggest to read following tip at SSP too :
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=8440

Andy Davis
Activecrypt Team
--------------------------------------------
SQL Server Encryption Software
http://www.activecrypt.com
Go to Top of Page

subu
Starting Member

2 Posts

Posted - 2010-06-22 : 08:15:11
quote:
Originally posted by perryplyang

Hi All,

I am new to SQL program. I did little management for SQL 2000 before.
I need to export from a table or view to excel spreadsheet for company's marketing resourece. Is there any easy simple way to do it?

Thanks all for your help.

Perry Yang



Hi,
Open excel 2007 - Go to Data - From Other Data Source - Select Microsoft Query - Select New Data Source - click Ok - Three thing to be filled - 1> Type the same name as SQL Database - 2> SQL Server - Click on Connect Select the Name of SQL Server Enter Username and Password click on option enter Database Name click ok 3 > Select Name of the Table which you want to export to Excel.
This will help you,
Subu
Go to Top of Page

subu
Starting Member

2 Posts

Posted - 2010-06-22 : 08:16:59
quote:
Originally posted by perryplyang

Hi All,

I am new to SQL program. I did little management for SQL 2000 before.
I need to export from a table or view to excel spreadsheet for company's marketing resourece. Is there any easy simple way to do it?

Thanks all for your help.

Perry Yang



Hi,
Open excel 2007 - Go to Data - From Other Data Source - Select Microsoft Query - Select New Data Source - click Ok - Three thing to be filled - 1> Type the same name as SQL Database - 2> SQL Server - Click on Connect Select the Name of SQL Server Enter Username and Password click on option enter Database Name click ok 3 > Select Name of the Table which you want to export to Excel.
This will help you,
Subu
Go to Top of Page

uberman
Posting Yak Master

159 Posts

Posted - 2010-06-22 : 09:14:11
If this is a one off and the table/view is not too big you could just do a copy and paste from Management Studio into Excel...
Go to Top of Page

Jinasoso
Starting Member

5 Posts

Posted - 2011-03-08 : 23:55:21
I want to introduce you one article which shows the method to export data to Excel. I think that the article can help you.
You can read the article from
http://www.dotnetspider.com/resources/42388-Export-Customized-Format-Data-Excel-without.aspx
Go to Top of Page
   

- Advertisement -