xml spy
Previous  Top  Next
Setting up the ADO or ODBC connection using the ODBC Data Source Administrator

This example uses Microsoft Access as the target database. The exported data can be imported using either an ODBC or an ADO data connection.

To set up a Database connection:

1.Click the Start button and select Settings | Control Panel. Then double click the Administrative tools folder.  
tut_s1_odb1  
2.Double click the Data Sources (ODBC) icon, to open the ODBC Data Source Administrator dialog box.  
tut_s1_odb3  
3.Click the Add... button to define a new data source.  
tut_s1_odb3a  
4.Select the Microsoft Access Driver (*.mdb) driver for the data source, and click the Finish button.  
tut_s1_odb4  
5.Enter "shape" as the Data Source Name, and enter a description in the Description field.  
6.Click the Select button and select the previously exported database (Data_shape.mdb). Confirm the selection with OK.  
The file name and path appear above the Select button.  
7.Click the OK button to confirm these settings. The Data Source Name "shape" appears in the User Data Sources list.  
tut_s1_odb5  
8.Click the OK button to complete the connection setup, and close or minimize the Administrative Tools folder.  
You are now ready to import MS Access table data hierarchically into XML Spy.  
9.Switch back to XML Spy to start the import process.  


Previous  Top  Next

© 2002 Altova