To convert tables from your database into an XML file:

  1. Create an ODBC connection using the ODBC control panel which points to your database server and whose default database is the database you wish to access.
  2. Launch SQL2XML.
  3. Enter the Data Source Name (DSN) of the ODBC connection you created.
  4. Click on the Get Tables button.  SQL2XML will then create a list of tables with default selections of  nested tables.
  5. Click to select which tables whose data you want as top-level elements in your XML document.
  6. Click to expand these tables, and then click to select which other table data you want included in the top-level elements.
  7. Click on Convert and specify the file to create.

 

screenshot