Unable to import empty excel cells into access

[ili_sophia]

Hi there,

I have a form in access where it allows the users to browse an excel worksheet and import it into the table.

the table gives an error of Type conversion failure when i try to import an empty cell into the access table for this specific column "Diff"

The settings are
Field size: Long integer
decimal place: Auto
default value: 0
required: No
Indexed: No
Text align: General

I have these settings the same for other columns and it is able to accept the empty cells only this particular column of "Diff" is not able to do so

Does anyone know why?

Thanks!

 

[Ranman256]

are you sure its 'empty'? Sometimes it just looks empty.
because otherwise there'd be no conversion.
I import empty fields all the time with no errors.

you could try :attach (link) the sheet as an external table,
build an append query , bring down all the fields into the query, assign their target fields,
and for every numeric field ,convert it to zero using:
NZ([field],0)

 

[Mark_]

"Diff" sounds like it may have an expression in it. Is "Diff" the difference between two cells? If so, as a calculated value you would not normally store the results in a table.

 

[ili_sophia]

Is there a way to do it without creating an external table

The fields only consist of values no calculated values

I have attached an example. it is not able to import rows 30-34