Problem exporting to Excel

[boreal]

InfoPath problem with exporting data to Excel 2003:
i) Within InfoPath (at a completed form), select File > Export to > MS
Office Excel
ii) At the “Export to Excel†wizard hit Next
iii) User is prompted to “Choose the type of data you want to export†with
choices “Form fields only†or “Form fields and this table or list†– Choose
the later to capture all data in the form
iv) The problem is that at this point, the user can only select one of the
listed tables or lists – What can the user do to select all of the data on
the form for an export to Excel? My form has several repeating sections and
when I export to Excel, only data from one repeating section is exported.

This InfoPath file was not created with SP1 installed, but SP1 features were
added to the file (option was given on opening the form in design view).
This did not change the above problem.

 

[WLA]

I am sory I don't have an answer to your question, but have one of my own on
a download problem. Do you know how to get around the 256 field limitation
on exported data form InfoPath to Excel? In addition, do you know how to
save the selection of fields that are made prior to completing the export
wizard so that it may be used at a later time?

Thanks,

-WLA-

 

[Matthew Blain \(Serriform\)]

An idea for both questions:

Turn the problem around. Open the XML file with Excel and use its XML data
mapping functionality. (Though I'm not sure if this is available in all
versions of Excel, you may need the Professional Enterprise edition.)

The reason you can only export one table is that InfoPath generates a single
flat list. How would you join the multiple tables into one list? You might
know for your scenario, but that's not going to be a general answer.

--Matthew Blain
http://tips.serriform.com/
http://www.microsoft.com/mspress/books/7128.asp