I am trying to import an exact copy of a table from one Access db to another,
but one field won't transfer b/c it's a lookup field. As such, its data type
is Number, but of course, it looks up & displays text. So I get a type
mismatch error.

For example, the field is Product Id & looks up the product name & number
from the Product table, but it only displays the name in the lookup field. Of
course, to be a lookup field, its data type has to be a number.

When I try to either copy & paste or import, or append, I can't get past the
fact that the data is in text format, when I'm trying to add it to a number
field.

What do I need to do to get this data to transfer between these two tables?

thanks, gina