Microsoft Xml Notepad

Shared database access is usual in any business environment. If you have a thorough knowledge of your Access database to Microsoft and updating of various applications, it will be much easier for you. Such occasions when you need to exchange information with programs for which data is formatted differently pain can sometimes be so you do not have a thorough knowledge of your management system database. It is not very easy process and is usually tedious and cumbersome. There is much room for errors in these transfers. But you have a good knowledge of database access technologies for the conversion, you can easily eliminate these problems and allow you to handle such situations in the most legitimate.

Once you collect data in different file formats such as XML, it can be an important task of database management as XML is considered one of the most widely used file format for storing data. XML is one of the most important and widely used file formats that are used for many documentation. Here are some steps that will guide you to import XML data and schema in a database access.

* You must open the XML or XSD file in Notepad that you want to import, then check the data to be imported

* You must open the database and the desired tab and external data in the Import group, you're supposed to click on XML

* You must click on Browse to External * XML data file dialog box to locate the XML or XSD file

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

* Click OK in the get external data - XML dialog box

* Dialog XML import, select the desired option in the selection of import options, and then click OK

* When the file type is XSD and click OK

* Click OK in the get external data - dialog XML file

* You can open the imported table and check the structure if the need

You can import XML data in your Microsoft Access in this way.