Data type mismatch issue

[Gary P]

When linking tables using an ODBC connection to Access 2003 some of the data types come over as Text instead of Number. I have no write permissions to the tables but I had it confirmed that the data type in the linked table was Number. Any thoughts on why it converts the data type?

[colintis]

The source table may contains some other characters such as symbols rather than just pure numbers, check again with the data inside if there's anything other than numbers.