Bug #15941 Errors Exporting ODBC From Access to MySQL
Submitted: 22 Dec 2005 19:37 Modified: 22 Dec 2005 20:02
Reporter: Colin Kendall Email Updates:
Status: Won't fix Impact on me:
None 
Category:Connector / ODBC Severity:S2 (Serious)
Version:3.23.38 OS:Microsoft Windows (XP)
Assigned to: MySQL Verification Team CPU Architecture:Any

[22 Dec 2005 19:37] Colin Kendall
Description:
I have an Access data base which I use to prepare data in a table for export into MySQL.  Once the data is prepared in Access, I delete the table from MySQL, then export it from Access to MySQL using ODBC.  However, I have found that the export from Access to MySQL causes date values to be converted to timestamps, and nulls are populated with todays date/time instead of remaining null.  I would like to fix this problem with out upgrading MySQL versions.  Please advise if you can.

Thanks,

Colin Kendall
ck@nthconsultants.com

How to repeat:
On a machine with MySQL 3.23.38, and MS Access:
Create an Access database table containing a date/time column.  Populate the table with some test data, leaving the date field null here and there.   Create an ODBC connection to the MySQL data base in windows.  From within Access, right click on the table and select Export, then in the Save as type: dropdown scroll down to ODBC then select the ODBC connection you created above.  Once the table is exported to MySQL, check the values in the DateTime column that was imported.  The Null values are populated with todays date/time and the design properties on the column are set to not allow nulls. 

Suggested fix:
?
[22 Dec 2005 19:40] Colin Kendall
Edited this bug report to upgrade Severity from Non-Critical to Serious.
-Colin
[22 Dec 2005 20:02] MySQL Verification Team
Please use the MySQL Migration Toolkit which was designed for this kind
of operations. You can download it at:

http://dev.mysql.com/downloads/migration-toolkit/1.0.html

Thank you for the bug report.