G
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?
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?