access / SQL annoyance

[yoda]

ok, a friend has passed to me a problem with his access database and his SQL database...
basically their is a data discrepency.... it looks like he's updated one, but not the other....
my problem is....
In the access DB the ID is a number and in SQL it is text so, I can't directly join the tables...

Anyone know a way around this other than changing the ID column in the access DB to text to match the SQL DB?

Thanks

 

[yoda]

the SQL has additional records than the access database that use letters....

 

[yoda]

yes the field does... and no I can't change the colums in the SQL server....

What about changing the access database so that the ID is text? the ID field in access is not auto generated...