Linking different field types

[Guest]

I have two tables, each from a different Oracle DB that I am linking to via
ODBC. I need to link these two tables by a specific field in order to run a
report, however the field I need to link is saved in one table as a Number
(decimal, precision 10) and in the other table as Text (varchar 12 I think).
I tried to build a query to change my text field into a decimal before
linking (the text field table is the much smaller table), and when I click
the view button in the query window, I get results, but only for a split
second before I get the "data type mismatch" error. I'd love to be able to
convert the decimal value to text, but the table is so huge, access can't
handle it (or I'm doing something wrong, I get the "out of memory" error,
even after compacting). Is there a way to link these tables without killing
access or my computer's processor?

 

[Douglas J. Steele]

Can you create a view in Oracle that does the conversion for you?

 

[Guest]

Not that I know of. The Oracle server is run by a contracted third party, so
I have no access to anything but the "views" of the tables....no queries.