MySQL "You tried to assign the Null value to a variable that is not a Variant data type. (Error 3162

[Dale Walker]

I'm trying to append a load of data from a simple Access 2003 table
containing email addresses and names to MySQL

I've managed to link the MySQL table but I can't append the data to it
as I keep getting

"You tried to assign the Null value to a variable that is not a
Variant data type. (Error 3162)" error messages.


My Access table looks like this :-

EmailAdd (primary)
FieldSize: 75
Required : Yes
Allow Zero Length: No
Indexed : Yes (No Duplicates)

Name
FieldSize: 75
Required: No
Allow Zero Length: Yes
Indexed:No


My MySQL table looks like this:-

EmailAdd
Type: Varchar(75)
AllowNull: No
Key: Primary

Name
Type VarChar(75)
AllowNull: Yes


There are no duplicate email addresses in the list nor are there any
empty/Null entries in that field either. There are however, occasional
blanks in the name field but I thought I've dealt with that on both
sides.

Any idea what else I need to do?

 

[Dirk Goldgar]

I'm trying to append a load of data from a simple Access 2003 table
containing email addresses and names to MySQL

I've managed to link the MySQL table but I can't append the data to it
as I keep getting

"You tried to assign the Null value to a variable that is not a
Variant data type. (Error 3162)" error messages.


My Access table looks like this :-

EmailAdd (primary)
FieldSize: 75
Required : Yes
Allow Zero Length: No
Indexed : Yes (No Duplicates)

Name
FieldSize: 75
Required: No
Allow Zero Length: Yes
Indexed:No


My MySQL table looks like this:-

EmailAdd
Type: Varchar(75)
AllowNull: No
Key: Primary

Name
Type VarChar(75)
AllowNull: Yes


There are no duplicate email addresses in the list nor are there any
empty/Null entries in that field either. There are however, occasional
blanks in the name field but I thought I've dealt with that on both
sides.

Any idea what else I need to do?

I don't know anything about MySQL, but the table definitions look okay
to me. Post the code or SQL you're using to append the records, and
maybe something will become evident.