Update Query Type Conversion Failure

[Guest]

All,

Thanks in advance for all your help, this is a great source for help.

I have a Table (Table1) that I imported from a spread sheet. I'm trying to
get all the values in a field of Table1 to reference a Key ID from another
table (Table2) via lookup (This is so that when I change a value in the
Lookup table (Table2) it updates all the values in the field used in Table1).
The Values in the field currently are Text. The Key ID is a (AutoNumber).
I used the lookup Wizard to create the Combo Box that allows me to choose
values from the Table2. When I go in and Change a value in Table1 (I know I
should not be entering data via tables but the Database is under development
with info from the Spread Sheet) it gives me an error. Something about "The
value you entered isn't valid for this field. For example, you may have
entered text in a numeric field..." After I click on OK three times it lets
me select from the combo box. I figure that this is an error message that
it's been weighting to give to me. I've tried to make a copy of the table
then run an update query from the copy of Table1 to the original Table1
hoping that it will choose values from the dropdown list and place it into
the intended field. But it gives me an error message like "didn't update ##
fields(s) due to a type conversion failure..."

What can I do to fix this problem?

 

[John Spencer]

If you imported data from a spreadsheet, you might have some fields that
didn't convert properly. Check the data you imported for #Error or other
values that don't match what you expect to be in the field.

 

[Guest]

The data in the inported field is like a bunch of e-mail address (numbers and
letters). I looked at the field and it's expecting text. But the dropdown
combo box is bound to the ID field of the Sub table (Column count = 3, Bound
Column = 1, Column Withs = 0", 2", 1",). Does that mean that it's looking
for / storing the ID in this field? How do you inport valuse to a field that
is linked to a lookup table.