Can I export a data access page to static HTML?

[andreas_udby]

Good morning! I'm using Access to redesign our company's electronic phonebook. Our intranet uses SharePoint technology and our IT people have cranked our security settings up pretty high, so I can't use data access pages or ASP. Therefore, I'm going to use static HTML, producing a single page which the CEO's secretary will upload once a month, allowing our 800+ employees to view the entire phonebook at once. CTRL-F is their friend.

I've managed to design a data access page that looks very much like we want it to, but I don't know how to export it to static HTML. Can such a thing be done, or am I just being wacky? If so, is there a way to automate it so the secretary can just push a button to generate the page?

Thanks,
Andreas

 

[John.Woody]

You could build a static html template and then search for info on the

Print #

command. Using this you could add db data to the template before uploading it to the website.

I have used this method to build thousands of html pages in to a catalogue to be burnt on to a CD which then doesn't need a db engine to be read.

hth

 

[andreas_udby]

Hmmm... okay. I understand making an HTML template. My issue is almost the reverse of yours -- I need to make just a single HTML page. I can easily print a report into HTML, but it creates 23 separate HTML pages, and I want just one. That's why I was trying to do this through a DAP and not a report -- I can set up a DAP to have all the data on one long page as opposed to 23 separate pages.

I'll see about pasting some screenshots into a Word doc and posting it.

Thanks,
Andreas

 

[andreas_udby]

Woo-hoo! I figured something out!

Apparently, if you export a report to XML, it will print to one page rather than multiple pages, which is what you get exporting to HTML. Thank goodness! Problem solved!

Thanks!
Andreas

 

[raymond35]

I think that the third party Add-in can meet your requirements quickly. I know one named Spire.DataExport which can export data from Access to Excel, Word, HTML and so on.
And it has released the free data export component which also can export data from Access to HTML. Maybe you can try to use it by downloading from E-iceblue.com/Download/download-dataexport-for-net-now.html