https://www.infopathdev.com:443/forums/46.aspx For questions concerning issues in the integration of SharePoint and Microsoft InfoPath.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/93263.aspxWed, 25 Sep 2013 14:14:16 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:93263JohanSoderdahl0https://www.infopathdev.com:443/forums/thread/93263.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=46&PostID=93263<font size="3" face="Times New Roman"> </font><p style="margin:0cm 0cm 0pt;" class="MsoNormal"><span style="mso-ansi-language:EN-US;">When exporting data from a database in SP to excel, data is exported as text. This makes numerical data difficult to use in Pivot tables. Currently the Excel sheets needs to be manually reformatted every time a post is added to the database and the excel sheet is updated.</span></p><font size="3" face="Times New Roman"> </font><span style="font-size:10pt;mso-ansi-language:EN-US;mso-fareast-language:NO-BOK;mso-bidi-language:AR-SA;">There seems to be a possibility in the InfoPath form where export type can be selected. However, whatever value we select, the outcome is still “single line of text”, except for one field of dates where the format is “date3 and time” and the fields with names where the format is “Person or Group”</span>