Exporting HTML Table to MS Word?

[A 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 word, I
need a script(JS or VB) that will automatically export or open the Query to
word.

[Brad Kingsley]

If you give the new page an extension of .doc, then Word should open the
client's desktop and display the page for them.

--
~Brad Kingsley
Microsoft MVP - ASP/.Net
Windows 2000 MCSE

http://www.orcsweb.com/
Powerful Web Hosting Solutions
#1 in Service and Support



"A P" <[e-mail]> wrote in message
news:%2****************@TK2MSFTNGP12.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 word, I
need a script(JS or VB) that will automatically export or open the Query
to
word.

[Jeff Cochran]

On Mon, 6 Sep 2004 10:00:50 +0800, "A P" <[e-mail]> 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 word, I
need a script(JS or VB) that will automatically export or open the Query to
word.

See:

http://support.microsoft.com/default...b;en-us;311461

Jeff

[A P]

its very complicated. Why is it like that? I notice on excel, you only need
to include this line?

Response.ContentType = "application/vnd.ms-excel"

Then you can convert html tables to excel.

"Jeff Cochran" <je*********@zina.com> wrote in message
news:41*****************@msnews.microsoft.com...

On Mon, 6 Sep 2004 10:00:50 +0800, "A P" <[e-mail]> wrote:

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

See:

http://support.microsoft.com/default...b;en-us;311461

Jeff

[Coz]

Its complicated because that is a .net example - .net is complicated....
seems to be about all it is for me !

There is the equivalent for your "application/vnd.ms-excel" ...

application/msword

Try these:
http://ppewww.ph.gla.ac.uk/~flavell/...tent-type.html
http://www.utoronto.ca/ian/books/htm.../mimetype.html

both pretty useful.
"A P" <[e-mail]> wrote in message
news:Og**************@TK2MSFTNGP12.phx.gbl...

its very complicated. Why is it like that? I notice on excel, you only need to include this line?

Response.ContentType = "application/vnd.ms-excel"

Then you can convert html tables to excel.

"Jeff Cochran" <je*********@zina.com> wrote in message
news:41*****************@msnews.microsoft.com...

On Mon, 6 Sep 2004 10:00:50 +0800, "A P" <[e-mail]> wrote:

Is this possible? I am planning to export data from SQL that generates HTMLtable. Instead of selecting the table and then copy then paste to word, Ineed a script(JS or VB) that will automatically export or open the

Query

toword.

See:

http://support.microsoft.com/default...b;en-us;311461

Jeff

[A P]

thanks!
"Coz" <co*@nospamcoz.com> wrote in message
news:#S**************@TK2MSFTNGP12.phx.gbl...

Its complicated because that is a .net example - .net is complicated....
seems to be about all it is for me !

There is the equivalent for your "application/vnd.ms-excel" ...

application/msword

Try these:
http://ppewww.ph.gla.ac.uk/~flavell/...tent-type.html
http://www.utoronto.ca/ian/books/htm.../mimetype.html

both pretty useful.
"A P" <[e-mail]> wrote in message
news:Og**************@TK2MSFTNGP12.phx.gbl...

its very complicated. Why is it like that? I notice on excel, you only

need

to include this line?

Response.ContentType = "application/vnd.ms-excel"

Then you can convert html tables to excel.

"Jeff Cochran" <je*********@zina.com> wrote in message
news:41*****************@msnews.microsoft.com...

On Mon, 6 Sep 2004 10:00:50 +0800, "A P" <[e-mail]> 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

word, I

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

Query

to

>word.

See:

http://support.microsoft.com/default...b;en-us;311461

Jeff

[A P]

how about setting page margin on ms word? can I control that thru asp?
"A P" <[e-mail]> wrote in message
news:#w**************@TK2MSFTNGP11.phx.gbl...

thanks!
"Coz" <co*@nospamcoz.com> wrote in message
news:#S**************@TK2MSFTNGP12.phx.gbl...

Its complicated because that is a .net example - .net is complicated....
seems to be about all it is for me !

There is the equivalent for your "application/vnd.ms-excel" ...

application/msword

Try these:
http://ppewww.ph.gla.ac.uk/~flavell/...tent-type.html
http://www.utoronto.ca/ian/books/htm.../mimetype.html

both pretty useful.
"A P" <[e-mail]> wrote in message
news:Og**************@TK2MSFTNGP12.phx.gbl...

its very complicated. Why is it like that? I notice on excel, you only

need

to include this line?

Response.ContentType = "application/vnd.ms-excel"

Then you can convert html tables to excel.

"Jeff Cochran" <je*********@zina.com> wrote in message
news:41*****************@msnews.microsoft.com...
> On Mon, 6 Sep 2004 10:00:50 +0800, "A P" <[e-mail]> 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 word, I
> >need a script(JS or VB) that will automatically export or open the

Query

to
> >word.
>
> See:
>
> http://support.microsoft.com/default...b;en-us;311461
>
> Jeff