Convert Excel spread sheet to an XML document.
Version Compatibility: Visual Basic 6, Visual Basic 5
This code demonstrates how to convert EXCEL spread sheets to an XML document. This sample uses ADO 2.5 or Higher. It demonstrates how to connect to an Excel spreadsheet using ADO and how to the save method of an ADO recordset to persist it to an XML file.
Instructions: Click the link below to download the code. Select 'Save' from the IE popup dialog. Once downloaded, open the .zip file from your local drive using WinZip or a comparable program to view the contents.