Bug #72431 MySQL Excel Plugin wont import DATE/DATETIME Columns due to Excel error
Submitted: 23 Apr 2014 13:16 Modified: 23 May 2014 15:19
Reporter: Steven Salerno Email Updates:
Status: No Feedback Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S2 (Serious)
Version:1.2.1.0 OS:Windows (Win7ult x64, Office2013)
Assigned to: CPU Architecture:Any

[23 Apr 2014 13:16] Steven Salerno 
Description:
When a Date or Datetime or Timestamp column exists in a table, you can't refresh data from DB nor import data from DB nor open a new sheet to edit mysql data, if the column that has the Date/Datetime/Timestamp is selected to be imported. See error in the How_To_Repeat section.

How to repeat:
Type of value has a mismatch with column typeCouldn't store <4/17/2014 12:00:00 AM> in DATE_ADDED Column.  Expected type is MySqlDateTime.

   at System.Data.DataColumn.set_Item(Int32 record, Object value)
   at System.Data.RecordManager.CopyRecord(DataTable src, Int32 record, Int32 copy)
   at System.Data.DataTable.ImportRow(DataRow row)
   at MySQL.ForExcel.Classes.MySqlDataTable.CopyTableData(DataTable filledTable)

To repeat:

- Create a table somewhere (even in Excel)
- Fill some data, the create table is in the Private Comments (assume table was created WITHOUT the DATE_ADDED column)
- Alter the table to include the DATE_ADDED column, setting all existing rows to have "4/17/2014" as the date
- Try to refresh the mysql data in excel, or create a new worksheet to edit
- Receive error

Suggested fix:
IDK
[23 Apr 2014 15:19] MySQL Verification Team 
Thank you for the bug report. I couldn't repeat please provide the output
of 'select * from master limit 3' using the mysql client. Thanks.
[24 May 2014 1:00] Bugs System 
No feedback was provided for this bug for over a month, so it is
being suspended automatically. If you are able to provide the
information that was originally requested, please do so and change
the status of the bug back to "Open".