Exporting and Merging Form Data
When your form users save XML file instances of the form, you can easily export them to an Excel file or merge them into another XML copy of the form.
To start an export to Excel, open one of the filled-in form XML files and then choose File 
Export to 
Microsoft Office Excel in InfoPath. Click Next in the first Export to Excel Wizard dialog box. Leave All Form Data selected and click Next. Click the Export Data from This Form and These Additional forms option button, click the Add button, and use the Add Files to Export dialog box that appears to select the form files to export. Click Finish back in the wizard, and the exported data opens in a new Excel file (Figure 39-18), which you can save and use the same as any other Excel database.
Tip
Remember, use Shift+click or Ctrl+click to select multiple files in any dialog box where you select or open files.
You must open a blank target copy of a form to merge data into it, choose File 
Fill Out a Form and then select File 
Merge Forms command in InfoPath. Use the Merge Forms dialog box that appears to select the XML form files; then click Open to finish the merge.
Tip
In Outlook, you can click the InfoPath folder for a form, right-click the list of e-mails, click InfoPath Actions in the shortcut menu that appears, and then click the Export Forms to Excel or Merge Forms command in that shortcut menu.