Export to excel through OLE automation


There are a few options other than using OPENROWSET to export  excel. From my research, the OLE Automation is a better option.  Here is a good link to show you how you can use OLE automation for this task with a user Stored Procedure.

The link:  http://www.simple-talk.com/sql/t-sql-programming/sql-server-excel-workbench/#first

Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s