gigifarrow
asked on
On my append query getting error messages, "Type conversion failure"," property value too large"
I have a query that when I go to append I get an error message,"Type conversion failure ". Then when I hit to preceed any way I get another error message saying, "property value too large",
Now the tables are the same all I did was copy and paste the table and rename it to make the table that it appends to.
appendQueryforcecklistnotworking.zip
Now the tables are the same all I did was copy and paste the table and rename it to make the table that it appends to.
appendQueryforcecklistnotworking.zip
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Thanks for the recognition of the answer!
---
I know the thread has aged a little, but as I was reviewing, I noticed that I forgot the link to a normalization description by MS, so here it is!!
http://support.microsoft.com/kb/283878
---
I know the thread has aged a little, but as I was reviewing, I noticed that I forgot the link to a normalization description by MS, so here it is!!
http://support.microsoft.com/kb/283878
Check the data types of all columns you're selecting vs. what you're inserting into.