![]() |
Previous Top Next |
Setting up the ADO or ODBC connection using the ODBC Data Source Administrator
|
1. | Click the Start button and select Settings | Control Panel. Then double click the Administrative tools folder.
|
![]() |
2. | Double click the Data Sources (ODBC) icon, to open the ODBC Data Source Administrator dialog box.
|
![]() |
3. | Click the Add... button to define a new data source.
|
![]() |
4. | Select the Microsoft Access Driver (*.mdb) driver for the data source, and click the Finish button.
|
![]() |
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.
|
![]() |
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.
|
|