Import and Export XML document using Microsoft access and Microsoft excel

To write a program to import and export xml document using Microsoft access and Microsoft excel.

PROCEDURE:

FOR MICROSOFT ACCESS
STEP 1: Start the process
STEP 2: Create the xml document using notepad.
STEP 3: Save the xml document as .xml extension
STEP 4: Click start->All programs->Microsoft office->Microsoft access 2007
STEP 5: To import the created xml document click->External data tab and XML option. STEP 6: Browse the location of xml document and click ok
STEP 7: Display the table
STEP 8: To export xml document click->External Data->more->XML file.
STEP 9: Then browse the location to save the document and click ok.
FOR MICROSOFT EXCEL
STEP 1: Start the process
STEP 2: Create the xml document using notepad.
STEP 3: Save the xml document as .xml extension
STEP 4: Click start->All programs->Microsoft office->Microsoft Excel 2007
STEP 5: To import the xml document click->Data tab ->From Other Sources->From xml data import.
STEP 6: Browse the location of xml document and click ok
STEP 7: View the table
STEP 8: Stop the process.