PDA

View Full Version : Join Error



PamK
05-16-2016, 06:17 AM
I have 2 tables that I am trying to join using Microsoft Query wizard. One table has 11,746 rows and the other 11,956. I am attempting a left join and I know there will be multiple matched rows for 200+, but I am getting an error "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data." Any suggestions?

mancubus
05-16-2016, 07:37 AM
?
http://www.dbforums.com/showthread.php?1676005-Field-Is-Too-Small-To-Accept-The-Amount-Of-Data-You-Attempted-To-Add