Stored Procedure to open and save as an Excel Spreadsheet

[SAC]

I need help in how to make a stroed procedure which will open an existing
file and rename it witha different file extention.

Current file is an "excel" spreadsheet, but it's an html file. It has a xls
extention, but when I open it in Excel and then click save as, the file type
defaults to html. So, I'd like to open it and save as a file type of xls
and I need a stored procedure to do this.

How can I do this?

Thanks for your help.

[Erland Sommarskog]

If you are on SQL 2005, you do it best from the CLR, although I don't
know exactly how much you can operate Excel from .Net.

If you are on SQL 2000, you would need to use the sp_OAxxx routines,
which is not really to recommend.

Overall, I would look for a different solution. SQL is not a general-
purpose language, and not really suitable for this task.

If this is something you want for your own convenience, VBscript or
Powershell are far better options.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[SAC]

I can do it in vb scrip, but how do I tie it into a job within sql? I need
it to run within a scheduled job.

Thanks for your help.

"Erland Sommarskog" <esq...@sommarskog.se> wrote in message
news:Xns9CEFF1CCF...@127.0.0.1...

[Erland Sommarskog]

SAC (s...@somewhere.com) writes:
> I can do it in vb scrip, but how do I tie it into a job within sql? I
> need it to run within a scheduled job.

You can set up a job as an Active-X script. Just chose that from the
drop down for job type.

[SAC]

Oh! Thanks!

"Erland Sommarskog" <esq...@sommarskog.se> wrote in message

news:Xns9CF1EF8C9...@127.0.0.1...