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 below
oracle number -->access integer
oracle 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 <TableName> failed
[microsoft][ODBC Driver Manager] SQL data type out of range(#0)
How to fix this issue?
newaccess