![]() |
Previous Top Next |
Exporting XML data to external databases
|
1. | Click the CompanyLast.xml tab on the main window, to make it the active document.
|
2. | Select the menu option Convert | Export to Text files / Database....
|
The default settings in this dialog export all elements, attributes, and generate primary and foreign keys.
|
![]() |
3. | Click the Export to Database button.
|
![]() |
This dialog allows you to select if you want to create a new Access table, export data to an existing one, or export to a third party database. The namespace option, "Exclude Namespace" is active per default.
|
4. | Click the Create a new Microsoft Access database entry, and confirm with OK.
|
5. | Enter the name of the new database in the "Save as..." dialog (e.g. Company.mdb), and confirm by clicking the Save button.
|
A progress indicator displays export progress and a message box appears when the process has been completed successfully. Click OK to confirm.
|
6. | Open the Company.mdb file you just saved. The export process automatically created a table for each exported element.
|
![]() |
7. | Double click the Person icon to open the Person table.
|
The table shows all the Person data from the XML file and includes the "Automatic fields" PrimaryKey and ForeignKey, which can be used to index the database data.
|
Please note:
|
If you select the "Create a new Microsoft Access database" option when exporting database data, XML Spy creates a new Access 2000 database!
|
If you want to export data to an Access 97 database, please create an empty Access 97 database first, and then select the export option "Choose an existing Access database". There are no restrictions when importing data from any Access database.
|
|