problem converting data from infopath forms in outlook to excel

[Liz]

Hi,
I’m really hoping someone can help me..
I have published a simple Infopath 2007 form with property promotion
enabled, which submits to my outlook account. I have stored the replies in an
Infopath form folder and converted the data they contain into an Excel
spreadsheet, which was straightforward.
My problem is that I have now created a more complex form and have found
that when I attempt to convert the data to Excel I get the message “The
contents of the specified XML data file have been truncated†and the
conversion fails. I can’t find any information on what this means, other than
the data is too large to fit in a cell, which doesn’t really help me. I need
to know specifically what it is that is preventing the conversion. Does
anyone know what the problem might be?
Thank you in advance
Liz

 

[BobCh]

Text fields will be truncated at 255 chars.

 

[Liz]

Thanks for replying. The text fields all contain less than 255 chars. I think
it may be the repeating sections in the form that are causing the message.
I'd just like to know for sure. It would be a really useful facility for me
to be able to capture all the returned forms in a spreadsheet. I would like
to know where I might be able to find out what the limitations on converting
the forms to Excel are.