Data type changes using ODBC...

From: Strange Cat _at_ Work <>
Date: Wed, 24 Jun 2009 11:18:13 +0200
Message-ID: <4a41ef9c$0$1110$>

Hello everyone,

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

Original text of this message