Export data from Access to HTML file and control the formatting (to be used in HTML Help)

[Vincent]

Hello All,

I would like to export structured data out of my Access database into
several HTML files (topics) that I can use in HTML Help Workshop in order to
create a .chm Help file.

Has anyone exported data out of MsAccess to a file in HTML format and also
wanting to control the layout? For example, having a query that joins a
'Title' and 'Contents' (etc) tables: the desired output should format the
title, a blank line, followed by the Contents text, followed by some other
details on separate lines (also formatted).

I can think of exporting a report to HTML (but that leads to separate files
per page). I also looked at the OutputTo method, but that doesn't give
enough control over the layout.

Ideas?

Thanks!

 

[Mike Painter]

Hello All,

I would like to export structured data out of my Access database into
several HTML files (topics) that I can use in HTML Help Workshop in order to
create a .chm Help file.

Has anyone exported data out of MsAccess to a file in HTML format and also
wanting to control the layout? For example, having a query that joins a
'Title' and 'Contents' (etc) tables: the desired output should format the
title, a blank line, followed by the Contents text, followed by some other
details on separate lines (also formatted).

I can think of exporting a report to HTML (but that leads to separate files
per page). I also looked at the OutputTo method, but that doesn't give
enough control over the layout.

Ideas?

I wrote a program that generated web pages by exporting the data to a text
file.
It was not very generic but could have been made so.
One table kept rows that are common in a page.
Another table kept the items I was selling.
I would out put the top of the page then loop through the items to create a
table, then output the bottom.
It worked but then I found a $20.00 program that did more....