Import data and schema from an XML file

1. Open a database, or switch to the Database window for the open database.
2. On the File menu, point to Get External Data, and then click Import.
3. In the Import dialog box, in the Files Of Type box, select XML Documents (*.xml).
4. Click the arrow to the right of the Look In box, select the drive and folder where the file is located, and then double-click its icon.
5. A list of tables contained within the XML document is displayed.

   Note   All of the tables shown in the list will be imported. You cannot select a subset of the XML document for importing.

6. In the Import XML dialog box, do one of the following:
   • To start importing the file, click OK.

     Note   For most records that cause an error, Microsoft Access creates and adds a row to a table called Import Errors. To view the list of errors that were encountered, open the Import Errors table from the Database window.

   • To cancel importing, click CANCEL.
   • To set options for importing, do one of the following:

     To import just the structure of the table, click Structure Only under Import Options.

     To import the structure of the table and the data, click Structure and Data.

     To append the data to an existing table, click Append Data To Existing Table(s).

   Note   For the first two options above, if a table already exists with the same name, a new table is created with a number appended to the name. Otherwise, a new table is created.