Any way to create excel files from SQL data without using DTS?

#1

Any way to use a normal stored procedure to create an Excel file from data
in a sql table?

Mark

#2

You need to use sp_OAGetProperty to read a properties value.

http://www.databasejournal.com/featu...0894_1459181_2

Darren

"Mark Andrews" <NOSPAMmandrews (AT) rptsoftware (DOT) com> wrote

Quote:

Any way to use a normal stored procedure to create an Excel file from data
in a sql table?

Mark

#3

This article lists some options...

Q321686 HOW TO: Import Data into SQL Server from Excel
http://support.microsoft.com/default...;EN-US;Q321686

-Doug

--
Douglas Laudenschlager
Microsoft SQL Server documentation team
Redmond, Washington, USA

This posting is provided "AS IS" with no warranties, and confers no rights.

"Mark Andrews" <NOSPAMmandrews (AT) rptsoftware (DOT) com> wrote

Quote:

Any way to use a normal stored procedure to create an Excel file from data
in a sql table?

Mark

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Any way to create excel files from SQL data without using DTS?

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Any way to create excel files from SQL data without using DTS? - 06-11-2004 , 03:13 PM

Re: Any way to create excel files from SQL data without using DTS? - 06-14-2004 , 11:24 AM

Re: Any way to create excel files from SQL data without using DTS? - 06-15-2004 , 03:13 PM