How to Upload XML to a Database

One of the most useful things about a database program is its ability to interact with many different kinds of programs. Even if other users do not have their own database programs, they can still provide input for the databases you create. You can, for instance, accept XML data from other sources and use that information to create a new table in your existing database. Once that table is created, you can use it as the basis for queries, reports, forms and other database elements.

• 1

  Open the database software and choose the database you want to import the XML data into. Click "File" and choose "Get External Data."

• 2

  Click the drop-down box next to "Files of Type" and change the file type to XML. Navigate to the folder containing the XML data and highlight the file. Click "Import" to bring in the file.

• 3

  Choose the "Structure Only" option if you want to import the field names and table structure but not the data. Choose "Structure and Data" to import both the XML table structure and the data it contains.

• 4

  Highlight the newly imported table and double-click it. Review the data to make sure it imported successfully.