| Author |
 Topic  |
|
|
perryplyang
Starting Member
Canada
3 Posts |
 Posted - 12/18/2005 : 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
Flowing Fount of Yak Knowledge
Nigeria
2702 Posts |
Posted - 12/18/2005 : 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 |
 |
|
|
Srinika
Flowing Fount of Yak Knowledge
Sri Lanka
1378 Posts |
Posted - 12/18/2005 : 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 |
|
|
|
madhivanan
Premature Yak Congratulator
India
22461 Posts |
|
|
perryplyang
Starting Member
Canada
3 Posts |
Posted - 12/19/2005 : 18:28:09
|
Thank you for all your help.
I will take a try.
Perry Yang |
|
|
|
perryplyang
Starting Member
Canada
3 Posts |
Posted - 12/19/2005 : 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 |
|
|
|
khtan
In (Som, Ni, Yak)
Singapore
16746 Posts |
Posted - 12/19/2005 : 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 |
|
|
|
activecrypt
Posting Yak Master
Germany
165 Posts |
|
|
subu
Starting Member
United Arab Emirates
2 Posts |
Posted - 06/22/2010 : 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 |
|
|
|
subu
Starting Member
United Arab Emirates
2 Posts |
Posted - 06/22/2010 : 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 |
|
|
|
uberman
Posting Yak Master
153 Posts |
Posted - 06/22/2010 : 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... |
|
|
|
Jinasoso
Starting Member
5 Posts |
|
| |
Topic |
|
NEW SQL- How to export table to excel spreadsheet?
