I have two table (oracle linked table and access table) with same structure except data type in oracle database and access.
data type convert as
oracle number -->access integer
varchar2(80_-->access text size 50
there are only tow column. no index and key.
the error message as
ODBC-- insert on a linked table test1 failed. ODBC driver manager SQL data type out of range (#0)
How to fix this issue?
newaccess
data type convert as
oracle number -->access integer
varchar2(80_-->access text size 50
there are only tow column. no index and key.
the error message as
ODBC-- insert on a linked table test1 failed. ODBC driver manager SQL data type out of range (#0)
How to fix this issue?
newaccess