To convert tables from your database into an XML file:
- 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.
- Launch SQL2XML.
- Enter the Data Source Name (DSN) of the ODBC connection you created.
- Click on the Get Tables button. SQL2XML will then create a list of tables with default selections of nested tables.
- Click to select which tables whose data you want as top-level elements in your XML document.
- Click to expand these tables, and then click to select which other table data you want included in the top-level elements.
- Click on Convert and specify the file to create.
