473,237 Members | 1,084 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,237 software developers and data experts.

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.
Jul 19 '05 #1
6 5739
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" <ap@textguru.ph> 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.

Jul 19 '05 #2
On Mon, 6 Sep 2004 10:00:50 +0800, "A P" <ap@textguru.ph> 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
Jul 19 '05 #3
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" <ap@textguru.ph> 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

Jul 19 '05 #4
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" <ap@textguru.ph> 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" <ap@textguru.ph> 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


Jul 19 '05 #5
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" <ap@textguru.ph> 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" <ap@textguru.ph> 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



Jul 19 '05 #6
A P
how about setting page margin on ms word? can I control that thru asp?
"A P" <ap@textguru.ph> 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" <ap@textguru.ph> 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" <ap@textguru.ph> 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



Jul 19 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
5
by: Jayjay | last post by:
Is it possible to export a report to word and have it include the graphics that are in the report? I'd like to take some of our reports and export them to word so we can email those to the...
4
by: Otis Hunter | last post by:
I have been given an Access Database which contains a table that has an OLE object field that contains a Word document. That table contains hundreds of records. I would like to find out how I can...
0
by: Otis Hunter | last post by:
I have been fighting with this for days and your expert help is needed! Below is the code I am executing which results with "Object doesn't support this property or method". The error is occuring...
5
by: mik18 | last post by:
I'm having trouble with exporting reports to Word in the rtf format and I'm hoping someone has a solution. The reports are losing their formats. Not all the formating is lost but some is and of...
3
by: gowens | last post by:
I have an ASP.Net multi-part tabbed page. One of the tab pages contains several controls (including a DataList). The DataList contains, virtually-rendered, Database images and some text fields....
6
by: Kevin Humphreys | last post by:
Hi There, I am trying to export a recordset to an excel file using the Content Type below in the header. Response.ContentType = "application/vnd.ms-excel" Which works fine however the...
2
by: Mux | last post by:
I am facing the following problem while exporting data to Word. The current implementation is as described below: I have a JSP file which has a link that enables you to export the data to Word....
4
by: Sonnich | last post by:
....is it the posssible to: format a field as "currency" or "number"? format a field as a formula? I create my sheet as a table Response.ContentType = "application/vnd.ms-excel"...
0
by: jianzs | last post by:
Introduction Cloud-native applications are conventionally identified as those designed and nurtured on cloud infrastructure. Such applications, rooted in cloud technologies, skillfully benefit from...
0
by: abbasky | last post by:
### Vandf component communication method one: data sharing ​ Vandf components can achieve data exchange through data sharing, state sharing, events, and other methods. Vandf's data exchange method...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 7 Feb 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:30 (7.30PM). In this month's session, the creator of the excellent VBE...
0
by: fareedcanada | last post by:
Hello I am trying to split number on their count. suppose i have 121314151617 (12cnt) then number should be split like 12,13,14,15,16,17 and if 11314151617 (11cnt) then should be split like...
0
by: stefan129 | last post by:
Hey forum members, I'm exploring options for SSL certificates for multiple domains. Has anyone had experience with multi-domain SSL certificates? Any recommendations on reliable providers or specific...
0
Git
by: egorbl4 | last post by:
Скачал я git, хотел начать настройку, а там вылезло вот это Что это? Что мне с этим делать? ...
1
by: davi5007 | last post by:
Hi, Basically, I am trying to automate a field named TraceabilityNo into a web page from an access form. I've got the serial held in the variable strSearchString. How can I get this into the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: Aftab Ahmad | last post by:
Hello Experts! I have written a code in MS Access for a cmd called "WhatsApp Message" to open WhatsApp using that very code but the problem is that it gives a popup message everytime I clicked on...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.