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
 Generate excel-html file from SQL SERVER

Author  Topic 

a_claver1
Starting Member

4 Posts

Posted - 2004-02-10 : 18:56:06
Generate an html-excel file with any table. Does not need Excel to generate , because does not use Excel automation.

http://www.databasejournal.com/scripts/article.php/3300831

robvolk
Most Valuable Yak

15732 Posts

Posted - 2004-02-10 : 20:32:21
What about sp_makewebtask? It's specifically designed to generate HTML files from SQL Server queries, tables, etc.
Go to Top of Page

a_claver1
Starting Member

4 Posts

Posted - 2004-02-10 : 21:18:13
sp_makewebtask has problems with long text fields. (It cuts fields
at 255 char).
I oftenly need generate files with long text in a cell. (More than 255).

Go to Top of Page
   

- Advertisement -