Background: Import Data from XML File

Use the Import Data from XML File (IMPORT) program to import data from an XML file into your database. See Road Map for work flow.

Why Use a Native Disc

The file you import data from can reside on your PC (or network) or on a native disc.

  • Importing from a native disc is much faster since it the data does not have to be read on the PC and then transferred

  • Import files residing on your PC (or network) are limited to 512-characters

Re-Create a Mapping

If you inadvertently deleted a column from your Microsoft Excel spreadsheet, you need to follow this procedure to re-establish the mapping. Typing the field name does not re-create the mapping even if you type it correctly.

Note
You cannot add a new column to your spreadsheet. If you forgot to select a field, you must re-export the data.

  1. Open the file.

  2. Choose Data > XML > XML Source. Excel displays the XML mapped fields for this worksheet on the right side of the screen.

  3. Drag the field name to the heading row of an empty column. The name displays in bold when it has been successfully added.

  4. Enter the data that you deleted.