Problem importing excel with nulls

[S]

I have an excel 2007 worksheet that i am trying to import in access 2007.
One of the coloums in my excel sheet may or may not have data in it for each
record. When I try to import it, I get an error message "subscript out of
range"
If I delete that column and then try to import into access it's fine.
It seems the problem is access will not allow me to import the file if some
of the cells from the worksheet are empty. Is there away to get around this?

 

[OssieMac]

Hi,

Are you importing it into an existing table. If so, do you have any fields
with the Required property set to Yes because this is one cause of the
problem you describe.

There may also be other properties that cause a conflict. If can't get it to
work importing into an existing table, try importing into a new table and
compare the field properties until you find the problem.