MySQL Forums
Forum List  »  MySQL for Excel

Re: Cannot set Column <name> to be null. Please use DBNull instead.
Posted by: Javier Treviño
Date: March 27, 2014 02:28PM

Matt,
I read your bug report. You state in it that using blank values or NULL does not work, but on a quick test I could perfectly use blank values to insert them to a nullable integer column. As I mentioned in my previous response, the word NULL does not work, even in Excel it is not used for null values, the standard is to use an empty string.

So please update the bug report with exact information to reproduce this bug.

Thanks.

====================================
Javier Treviño
MySQL on Windows Team

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.