L
lynn. atkinson
I am trying to upload data from a spreadsheet in to my
database. I have imported the data in to a table which I
want to append to the relevant table. When I run an append
query I get the message
You tried to assign a null value to a variable that is not
a variant data type.
I think I get what this means, but not sure how to sort
it. the fields I am trying to append to are all text,
currency or number fields. I am appending to a table which
has an autonumber field, but this will automatically be
filled in when I create records by appending - am I
correct?
How do I find what the field is that is causing the
message?
I am under time pressure to get this data uploaded so any
help will be most welcome.
database. I have imported the data in to a table which I
want to append to the relevant table. When I run an append
query I get the message
You tried to assign a null value to a variable that is not
a variant data type.
I think I get what this means, but not sure how to sort
it. the fields I am trying to append to are all text,
currency or number fields. I am appending to a table which
has an autonumber field, but this will automatically be
filled in when I create records by appending - am I
correct?
How do I find what the field is that is causing the
message?
I am under time pressure to get this data uploaded so any
help will be most welcome.