Exporting HTML Table to Excel?

[M P]

Is this possible? I am planning to export data from SQL that generates HTML
table. Instead of selecting the table and then copy then paste to excel, is
ther a script(JS or VB) that will automatically export or open the Query to
it.

[Tom Kaminski [MVP]]

"M P" <mark@textguru.ph> wrote in message
news:enGRS5yYEHA.3844@TK2MSFTNGP10.phx.gbl...

> Is this possible? I am planning to export data from SQL that generates

HTML

> table. Instead of selecting the table and then copy then paste to excel,

is

> ther a script(JS or VB) that will automatically export or open the Query

to

> it.

See:
[url]http://support.microsoft.com/?kbid=199841[/url]
[url]http://support.microsoft.com/?kbid=301044[/url]

--
Tom Kaminski IIS MVP
[url]http://www.microsoft.com/windowsserver2003/community/centers/iis/[/url]
[url]http://mvp.support.microsoft.com/[/url]
[url]http://www.iisfaq.com/[/url]
[url]http://www.iistoolshed.com/[/url] - tools, scripts, and utilities for running IIS
[url]http://www.tryiis.com[/url]

[Bullschmidt]

Creating a Dynamic Report using ASP and Excel by Jeff Anderson -
1/9/2003
[url]http://www.codetoad.com/asp_excel.asp[/url]

Output To MSExcel
[url]http://www.codeave.com/asp/code.asp?u_log=40[/url]

ASP Tutorial: Dynamic Excel Reports
[url]http://www.aspalliance.com/stevesmith/articles/exceltutorial.asp[/url]

VBScript and Excel
[url]http://www.greggriffiths.org/webdev/both/excel/[/url]

HOWTO: Extract Information from Excel Sheet with DAO
[url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;190195[/url]

Updating Excel From the Web by Bill Jeffries - 10/21/1999
[url]http://www.15seconds.com/issue/991021.htm[/url]

Using Excel Spreadsheets as Web Data Sources by Steven B. Raines
[url]http://algonquinstudios.com/articles/excel_db.asp[/url]

Help: Inserting into Excel with ADO
Andres - 6/13/2001 1:35:38 PM
[url]http://www.aspmessageboard.com/forum/databases.asp?M=233741&P=1&F=21[/url]

Best regards,
J. Paul Schmidt, Freelance ASP Web Designer
[url]http://www.Bullschmidt.com[/url]
ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...


*** Sent via Devdex [url]http://www.devdex.com[/url] ***
Don't just participate in USENET...get rewarded for it!

[M P]

thanks! I really appreciate your response.

Mark

"Bullschmidt" <paul@bullschmidt.com-nospam> wrote in message
news:eJjToC4YEHA.4008@TK2MSFTNGP09.phx.gbl...

> Creating a Dynamic Report using ASP and Excel by Jeff Anderson -
> 1/9/2003
> [url]http://www.codetoad.com/asp_excel.asp[/url]
>
> Output To MSExcel
> [url]http://www.codeave.com/asp/code.asp?u_log=40[/url]
>
> ASP Tutorial: Dynamic Excel Reports
> [url]http://www.aspalliance.com/stevesmith/articles/exceltutorial.asp[/url]
>
> VBScript and Excel
> [url]http://www.greggriffiths.org/webdev/both/excel/[/url]
>
> HOWTO: Extract Information from Excel Sheet with DAO
> [url]http://support.microsoft.com/default.aspx?scid=kb;EN-US;190195[/url]
>
> Updating Excel From the Web by Bill Jeffries - 10/21/1999
> [url]http://www.15seconds.com/issue/991021.htm[/url]
>
> Using Excel Spreadsheets as Web Data Sources by Steven B. Raines
> [url]http://algonquinstudios.com/articles/excel_db.asp[/url]
>
> Help: Inserting into Excel with ADO
> Andres - 6/13/2001 1:35:38 PM
> [url]http://www.aspmessageboard.com/forum/databases.asp?M=233741&P=1&F=21[/url]
>
> Best regards,
> J. Paul Schmidt, Freelance ASP Web Designer
> [url]http://www.Bullschmidt.com[/url]
> ASP Designer Tips, ASP Web Database Demo, Free ASP Bar Chart Tool...
>
>
> *** Sent via Devdex [url]http://www.devdex.com[/url] ***
> Don't just participate in USENET...get rewarded for it!

[Greg Griffiths]

covered at [url]http://www.greggriffiths.org/webdev/both/excel/[/url]

M P wrote:

> Is this possible? I am planning to export data from SQL that generates HTML
> table. Instead of selecting the table and then copy then paste to excel, is
> ther a script(JS or VB) that will automatically export or open the Query to
> it.