Data type changes using ODBC...
Date: Wed, 24 Jun 2009 11:18:13 +0200
I am using Oracle ODBC to connect tables from an Oracle schema to an empty Microsoft Access DB.
In one particular table i have a VARCHAR2 field that is 255 chars long.
This field is reported as being of MEMO type in Access, which is untrue.
Problem is that another third-party (that reads the Oracle data sw) has problems using Memo fields.
Can anyone help me in forcing ODBC driver to report the field as TEXT in Access, as it should be?
Paolo Received on Wed Jun 24 2009 - 04:18:13 CDT