I am trying to append data to an Oracle 8i database from Microsoft Access
97. I setup a linked table in Access to the Oracle 8i table, using the ODBC
driver (Oracle ODBC driver: version 8.01.72). The connection seems to work
fine. I then create an append query from one table in access to the linked
Oracle table. When I run the append query, I get the following error:
"You tried to assign the Null value to a variable that isn't a variant data type."
Some of the rows in the Access data have null values in a couple of the
columns. However, this shouldn't be a problem, because none of those
columns are part of constraints, and they all allow null values in Oracle.
I've noticed that if I remove the rows with the null values, or don't
include the columns with the null values in the query, the append query runs
fine. What could be causing this problem? It's making it near impossible
to append rows to Oracle from Access.
Click Here to Expand Forum to Full Width