ili_sophia
Registered User.
- Local time
- Today, 18:44
- Joined
- Aug 23, 2017
- Messages
- 40
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!
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!