Transferring Data from Excel into HTML Pages Using XML Data Files	Visited: 1997 2.0/5.0 (3 votes total) Rate: Select 1 - Terrible 2 - Poor 3 - Average 4 - Good 5 - Outstanding
by meadinkent.co.uk June 09, 2006

This section offers some simple guidance of how to transfer data from Excel or Access into HTML web pages using XML data files. VBA programs can be used to export data tables from Excel or Access into simple XML files. There are several examples of using different methods to display the XML and XSL files on web pages in order to quickly share your data with others.

This site is not a tutorial on XML data tables or XSL. Suffice it to say that XML is a universal standard format for exchanging data between applications while XSL offers the ability to control its presentation (formatting), sorting and display criteria. The data can be viewed using web browsers such as Internet Explorer. The data however is separated and independent from the page used to display it.

Read on...