XML is a very simple and efficient way to exchange data between different computer programs. More and more companies choose to use XML files to move data back and forth, rather than using the Microsoft Access 2007 files. Most often you’ll be asked to send a XML file, which is easier to integrate with other reporting programs, rather than the high specialized .ACCDB database format.
In case the entire idea of using XML files scares you, then you have to know this: you don’t exactly need to know how XML looks like or works in order to use it. So, fear not the technology, just follow the instructions and Microsoft Access 2007 will produce the XML file for you.
In order to export Access data to an XML file, follow the steps:
For this tutorial, we’ll choose XML file (which you’ll be using most of the time anyway).
Fig3. Choose the type of file
If you need to export related tables as well, click on "More options". In this case, Table1 doesn’t have any other tables related to it.
Fig4. Choose the related tables, if any, to be added to the XML file
You can also choose to export any other tables that are related to the main table. For example, if any other table contained a look up column based on Table1, then the respective table would have shown under the Table1 in the "Lookup Data" section.
Microsoft Access is an application used to create small and midsize computer desktop databases for the Microsoft Windows family of operating systems. It can also be used as a database server for a web-based application.
This electronic book (ebook) provides lessons on how to use Microsoft Office Access 2007 to create and manage databases. The lessons follow a step-by-step format with practical examples.
Download the ebook now - Microsoft Office Access 2007 Desktop Databases