Import XML File In Access 2010

Today databases contain data in incompatible formats, which eventually begets the problem of exchanging data between systems over the internet. Converting data in to XML can mitigate the probable of encounter incompatibility problem. XML is use to store data in files or in databases, and through Access 2010 you can retrieve data from XML files for performing advance operations over it.

XML is made up of well structured table, it contains disparate data with parents and child nodes disperse in the document. XML supports user-defined tags, so there are no rules or constraints to follow.

To start off with lets get familiar with its structure.

{lines of code}

Here is an example of XML file

To import this file in to Access 2010, launch the application, head over to External Data tab and click XML File.

XMLbutton1 Import XML File In Access 2010

In Get External Data dialog, choose the XML file you want to import, and click OK.

wizard 1

A dialog will appear, which show the content of the XML file in a well structured tree format. By using Import Options you can also import only the structure of the data. Enable Structure and Data to import Data with its structure. Click OK to start importing.

Import XMl

XML data file is successfully imported in to Access as shown in the screenshot below. Open Design View to apply desired constraints over data fields.

imported data

قالب وردپرس

About Alyse Kalish

Alyse Kalish
As an Associate Editor for The SalesJobInfo, Alyse is proud to prove that yes, English majors can change the world. She calls many places home, including Illinois where she grew up and the small town of Hamilton where she attended Colgate University, but she was born to be a New Yorker. In addition to being an avid writer, Alyse loves to dance, both professionally and while waiting for the subway.

Leave a Reply

Your email address will not be published. Required fields are marked *