I created an Access 2010 database that has multiple data collection (InfoPath) forms that were generated from Access and have been in use for about 1.5 years. Starting in 2013 (for about a week now), the submitted data fails to Export due to a "data type conversion error" with the date fields. Prior to 2013, the date string returned in the InfoPath form looked like this: "2013-01-07T00:00:00", but now it looks like this: "2013-01-07T00:00:00-05:00". The time zone is appended to the string and it kills the Outlook Export feature.
To test this, I created a new database with one table and one date time field. I generated an InfoPath template and emailed it to myself. I entered the date into the template and submitted it (tried manually entering the date as well as using the date time picker control - made no difference). The InfoPath template now contains "2013-01-07T00:00:00-05:00" and will not Export from Outlook to Access. I tried manually pasting the string into the Access table and it would take it, but would show "1/7/2013 5:00:00 AM" in the date time field (which isn't correct either but at least it took). Note: This problem has appeared at my office (Win 7 with Office 2010), but my testing was done on my personal laptop using Win 8 with Office 2010.
It looks like Microsoft has created a bug and now all of my data collection forms are unusable. Any help will be appreciated.