🚀 go-pugleaf

      Another thought would be to have the Access database emit XML--I don't
      remember if Access can do this




Depends on the version. Access 2002 can. Select the table or query, then choose "Export" from the File menu and designate the XML file type. Here's an example of the result:

<?xml version="1.0" encoding="UTF-8" ?>
<dataroot xmlns:od="urn:schemas-microsoft-com:officedata">
<Events>
  <ItemID>1</ItemID>
  <Event>Evening Story Hour</Event>
  <StartDateTime>2003-01-27T18:30:00</StartDateTime>
  <Place>Marseilles Library</Place>
  </Events>
- <Events>
  <ItemID>2</ItemID>
  <Event>Preschool Story Hour</Event>
  <StartDateTime>2003-01-29T10:00:00</StartDateTime>
  <Place>Marseilles Library</Place>
  </Events>
- <Events>
  <ItemID>3</ItemID>
  <Event>Marseilles Blood Drive</Event>
  <StartDateTime>2003-01-30T12:00:00</StartDateTime>
  <EndDateTime>2003-01-30T17:00:00</EndDateTime>
  <Place>First Congregational Church, 255 E. Bluff St.</Place>
  </Events>
  </dataroot>

You can also export schemas and format the date by associating an XSL file.