XML is very much becoming the standard and the most efficient way to exchange data between different computer programs. More and more organisations choose to use XML files to move data back and forth, rather than using the Microsoft Access 2007 files.
In the coming days more often one will be asked to send a XML file, which is easier to integrate with other reporting programs, rather than the high specialized .ACCDB database format.
So here are a series of simple set of instructions to be followed on Microsoft Access 2007 and it will produce the XML file for you.
In order to export Access data to an XML file, follow the steps:
Click on the External Data Ribbon, then choose Export More XML File
Access will ask for the path to store the XML file. It will provide option to browse to the location to choose the path and name the XML file.
This involves the step to choose the file type. By defualt access provides 3 file types. Namely
Data (XML) – creates a XML file with all the content of all the records in the table as selected.
Schema (XSD) – it doesn’t contain any data, but stores the definition which describes the selected table.
Presentation (XSL) – defines how a browser can convert the data in the XML file into HTML web page (which displays normally online).
If one wants to export the related tables as well one can select the more option on this screen.Here in our example we choose the first option [Data(XML)].
Click on OK to generate the XML file.
If some one wants to repeat this same process without going through the wizard once again, then they can do so by checking the option “Save Export Steps”.
Thats it! you are done and can now send the XML file out.