How to Create an XML File from an SQL Database
You can use Hypertext Markup Language (HTML) and Cascading Style Sheets (CSS) to bind and format XML data on your web page and share your database with the world. XML defines a universal data structure, which provides a framework for making data understandable to a wide range of applications. Most applications will export data to an XML file, which works with most web browsers and can be edited in any text editor.
Other People Are Reading
Instructions
-
-
1
Open Microsoft Access. Click the "Office" button. Select "New" from the menu. Choose to create a "Blank Database." Click the "Create" button.
-
2
Click "More" in the "Import" group of the "Database Tools" tab. Choose "ODBC database" from the menu.
-
-
3
Select "Import the source data into a new table in the current database." Click the "OK" button.
-
4
Select the tables to link to from the pane beneath "Tables" in the "Link Tables" window. Choose a "Unique Record Identifier" for each table and click "OK" if prompted.
-
5
Select the table from the left pane. Click on "More" in the "Export" group of the "External Data" tab. Select "XML File."
-
6
Select a location for the file. Type a name for the file in the "File name" area. Click the "Save" button.
-
7
Check the box next to "Data (XML)" in the "Export XML" window. Click the "OK" button. Click the "Close" button.
-
1
