When I have seen this error it was caused by a field defined in the
MySQL database as NOT NULL in the Create table and the value in Access
is NULL or usually for us an empty field in EXCEL which is appears to be
intreped as NULL when you do a PASTE APPEND.
Ours is often times a datetime field but
Raj Goel wrote:
>Dan,
>
> Here's what I've narrowed it down to:
>
> We're updating FROM Access TO MySql.
>
> If the column in Access is blank/empty, then the error pops up.
>
> If the field has data, then the error does not pop up.
>
> So, somewhere, either Access, or
Edward Maas wrote:
>"You Tried to assign the Null value to a variable that is not a
> Variant data type."
> From my searching, I was unable to find how to set fields to variant
> data types. Secondly, I am not sure which field is causing the error.
No kidding. Looking into my crystal ball, I
