crawfordit
asked on
When linking Access 2000 to and Oracle 9i Database a number field in Oracle is reported as text in access
I am trying to link two tables out of an Oracle 9i database to Access 2000
After creating the database link I go to link the table sin the query window
Table 1 has 2 key fields Quote which is text and Line which is Number
Table 2 has 2 key fields Quote which is text and line which is also text.
I cannot link the tables because the field types for the Line fields are different.
I look at the Oracle table schema and the fields report type reports as Number type.
How can I correct or work arround the problem?
After creating the database link I go to link the table sin the query window
Table 1 has 2 key fields Quote which is text and Line which is Number
Table 2 has 2 key fields Quote which is text and line which is also text.
I cannot link the tables because the field types for the Line fields are different.
I look at the Oracle table schema and the fields report type reports as Number type.
How can I correct or work arround the problem?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.