A
albert.repasky
I am getting a Type conversion failure on all 10 records when I append
records to a table.
Message is:
Set 0 field(s) to Null due to a type conversion failure, and it
didn't add 10 record(s) to the table due to key violations, 0
records(s) due to lock violations, and 0 record(s) due to validation
rule violations.
It does not seem to be a key violation and no fields are required and
all fields Allow Zero Length.
I have seen the other postings and still can not resolve this. I am
importing another table and it works fine. Both tables come from 2
different Excel WS's and originally come from Peoplesoft.
I am using Access 2003.
Any ideas out there?
arep
records to a table.
Message is:
Set 0 field(s) to Null due to a type conversion failure, and it
didn't add 10 record(s) to the table due to key violations, 0
records(s) due to lock violations, and 0 record(s) due to validation
rule violations.
It does not seem to be a key violation and no fields are required and
all fields Allow Zero Length.
I have seen the other postings and still can not resolve this. I am
importing another table and it works fine. Both tables come from 2
different Excel WS's and originally come from Peoplesoft.
I am using Access 2003.
Any ideas out there?
arep