![]() |
Previous Top Next |
Importing a table using ODBC
|
1. | Select the menu option Convert | Import Database data...
|
![]() |
2. | Click the ODBC connection string radio button, and then the Build button.
|
![]() |
3. | Click the Machine Data Source tab, select the previously defined "shape" data source, and click the OK button. The ODBC connection string now appears in the text box.
|
If a User name and Password dialog box is opened at this point, enter the information as requested.
|
![]() |
4. | Click the Choose database table button and select the database table you want to import (in this case Person). The select statement SELECT * FROM "Person", appears in the Selection statement text box.
|
5. | Click the Preview button to see the database data.
|
6. | Activate the Exclude Primary/Foreign Keys check box, to avoid importing the key fields (this only applies to key fields that were created by XML Spy during the export process).
|
![]() |
![]() | Define and import this field as an Element.
|
![]() | Define and import this field as an Attribute.
|
![]() | Skip, do not import this field.
|
|
1. | Click the OK button of the database import dialog box, when you have decided which fields you want to import (no changes in this example).
|
![]() |
|
XML Spy creates an untitled XML file containing the Person table data. The root element is called Import, and each Person element is a table row.
|
|
|