How to Import XML into Microsoft Access Software

Sharing access database is usual in any business environment. If you have a thorough knowledge of your Microsoft access database and updating it various applications, it will be a lot easier for you. Such occasions where you need to exchange information with programs whose data is differently formatted can be pain sometimes if you don't have a thorough knowledge of your database management system. It is not very easy process and is usually tiring and bulky. There is a lot of room for errors in such transfers. But you have a good knowledge of access databases conversion techniques, you will easily be able to eliminate these problems and enable you to handle such situations in the most rightful manner.

Best Microsoft MCTS Training, Microsoft MCITP Training at certkingdom.com

Once you collect the data from various file formats, like XML, it can be an important database management task as XML is considered as one of the most widely used file formats for storing of data. XML is one of the most important and widely prevalent file formats which are used for many documentation purposes. Here are some steps that will guide you to import XML data and schema into an access database.

* You need to open the XML or XSD file in notepad that you wish to import and then verify the data that is to be imported

* You need to open the desired database and on the external data tab and in the import group, you are supposed to click XML

* You need to click browse on the get external data* XML file dialogue box, in order to locate the XML or XSD file

* Hen you need to navigate the folder containing XML or XSD file in the filr open dialogue box, then select the file and open it

* Then click OK in the get external data - XML dialogue box

* Import the XML dialogue box, select the desired option in the import option selection and then click OK

* If the file type is XSD, then click OK

* Click OK in the get external data - XML file dialogue box

* You can open the imported table and verify the structure if the need be

You can import XML into your Microsoft Access software in this way.