How to Load XML to a Database
- 1). Open the application that is used to manage your database. If the application is stored locally and you have a database file, you can also double click the database file to launch the application. If the application is stored online or over a network, then verify that you have any necessary usernames and passwords.
- 2). Select the database that the XML data will be loaded into. If the database has any additional password protection, enter the username and password.
- 3). Select the "Import" or "Get External Data" option, then specify that you are going to be importing an XML file. For example, in Microsoft Access 2003, you would click "File" at the top of the screen, then click "Get External Data" and choose "Import."
- 4). Locate your XML file and click the "Open" button.
- 5). Click the "OK" or "Go" button to import the XML file to your database.
- 6). Navigate to your database table listing to find the newly generated database table based upon your imported XML data. By default, most applications will give this table a name that corresponds to the first column name listed in the XML file.
Source...