export datetime column to excel then import again fails

Xpinator · Post by **Xpinator** » Mon 12 Jan 2015 12:31

I have a table with a couple of DateTime columns, I export it to Excel 2007 (xlsx), then edit the the date and save it.
when I try to import, the date is shown as a number, and the import fails.

the date of course is valid. even if I don't change it, just edit another column (text column) and try to import, it fails since the date is no longer valid...

anyone seen this before? my workaround is saving the excel file as CSV and then importing.

alexa · Post by **alexa** » Mon 12 Jan 2015 13:38

We are aware of this issue and will fix it in the next product build. We will notify you once it's available for downloading.

alexa · Post by **alexa** » Mon 26 Jan 2015 16:17

We would like to let you know that we have released a new build 6.3.339 of dbForge Studio for MySQL where the issue you reported is fixed http://www.devart.com/dbforge/mysql/stu ... nload.html

Thank you for your help in improving dbForge Studio for MySQL.

Devart Forums

export datetime column to excel then import again fails

export datetime column to excel then import again fails

Re: export datetime column to excel then import again fails

Re: export datetime column to excel then import again fails