![]() |
Previous Top Next |
Importing database data
|
1. | Select the menu option Convert | Import Database data....
|
![]() |
2. | Click the Choose file button, and select the Company.mdb file.
|
The cursor is placed in the Selection statement text box.
|
3. | Click the Choose database table button, select Person and confirm with OK.
|
The SELECT * from [Person] statement is now visible in the text box. You can extend the select statement, using standard SQL statements, to further filter the imported data.
|
![]() |
4. | Click the Preview button to see an example of the table data you intend to import. The Preview window displays only those records that fulfill the select criteria.
|
![]() |
![]() | Define and import this field as an Element.
|
![]() | Define and import this field as an Attribute.
|
![]() | Skip, do not import this field.
|
5. | Click the Element symbol of the PrimaryKey column, until the skip symbol appears. Do the same for the ForeignKey column.
|
6. | Click the Element symbol of the Degree column, until the attribute symbol appears. Do the same for the Manager and Programmer columns.
|
![]() |
7. | Click the OK button to start the import process.
|
8. | Select the menu option File | Save and name the XML document (e.g. Person-Import.xml)
|
|
![]() |
![]() |
For more information on importing data, please see the following sections in the reference section under Menus | Convert Menu | Convert How to...
|
· | Setting up an ADO or ODBC connection
|
· | Importing a table using ODBC
|
· | Importing hierarchical data - ADO Data shaping
|
· | Shape string examples
|
|
|