laughingdevil
New Member
- Joined
- Aug 5, 2011
- Messages
- 40
I'm having issues with importing data into access from excel, I get an error that I am unable to append because of key voilations.
Checking the log table produced it lists "Type Conversion Failure" for a specific cell, it seems to be NULL values which are causing a problem.
I am importing to a blank temp table, so no relationships etc and the field in question has
"Required" set to no and
"Allow zero length" set to yes
Any suggestions of how I can get round this issue?
Checking the log table produced it lists "Type Conversion Failure" for a specific cell, it seems to be NULL values which are causing a problem.
I am importing to a blank temp table, so no relationships etc and the field in question has
"Required" set to no and
"Allow zero length" set to yes
Any suggestions of how I can get round this issue?