lookup table issue (type conversion error)

  • Thread starter Thread starter ymk
  • Start date Start date
Y

ymk

Hi
I am trying to update columns in access 2003 using a lookup table which
works fine. However my issue is that the table is an existing one and the
fields already contains data. I have tried to do an update query to populate
the existing information using identical info as per the lookup table but it
won't update and error message indicated type conversion failure.

I tried to decipher using the help but got a bit lost...

any pointers would be much appreciated...
 
Type conversion error occur when recording telephone number, Zip codes, etc.
They appear a numerial but do not get added, substracted, or multiplied and
therefore need to be stored as text. Access is kinda helpful and when it
sees digits it thinks it is a number.
Check the datatype of the corresponding fields in the two tables by opening
in design view and looking at the properties.
Also numbers can be stored as Integer, Long Integer, Single, Double,
Currency, and decimal. Check to see if these match.
 
ymk said:
Hi
I am trying to update columns in access 2003 using a lookup table
which works fine. However my issue is that the table is an existing
one and the fields already contains data. I have tried to do an
update query to populate the existing information using identical
info as per the lookup table but it won't update and error message
indicated type conversion failure.

I tried to decipher using the help but got a bit lost...

any pointers would be much appreciated...
Click to expand...

Please post the SQL of the update query and the data types (from the
table definitions) from the relevant fields.
 
Back
Top