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
 Script Library
 Export from SQL to Server

Author  Topic 

Julie19
Starting Member

32 Posts

Posted - 2012-06-18 : 14:36:30
What is the best approach to export from SQL to Execel apart from DTS and the import/Export Wizard
This is because the data gets appended daily

Your help is greatly appreciated

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-18 : 14:52:29
you can use OPENROWSET or add excel as a linked server and use four part naming convention or OPENQUERY

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-06-19 : 01:47:33
Powershell is a good option - it has good facility for connectng to SQL server and Powershell.

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page

Julie19
Starting Member

32 Posts

Posted - 2012-06-19 : 08:52:31
Is there any code or steps to for the OPENrowset or link server
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-06-19 : 15:11:31
see

http://www.mssqltips.com/sqlservertip/1202/export-data-from-sql-server-to-excel/

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -