I have a column in a table that is tied to a Lookup Column.  When I import data either through copy/paste or CSV File, the Lookup Column is left blank when the text is 20 characters or longer.  It works as expected for my text that is 17 characters and 9 characters, but fails when I hit 20 characters.

The current work around is to remove the Lookup Column restriction on the column, do the import and then switch the column back to a Lookup Column.  All my data is retained as all the items are indeed in the table that the Lookup Column points to.  The problem with this method is that re-enabling the change fails as the column is refered to in a Query Table.  This then requires me to remove that column in all of my queries, re-add the Lookup Column and then re-add the column to all of my queries.

Rick