INTEGER in Oracle is TEXT or DECIMAL in MS Access 2

[iamareplicant]

Hi experts,

I have an Access2K3 database and am attempting to link tables via ODBC to Oracle 9.2.

In the Oracle tables, we have tried a zillion combos of INTEGER(x,y) for a data type in a test table, but still, in Access after I link to the oracle table, the data type for that field shows as type TEXT, or when we do get Access type of NUMERIC, we get a DECIMAL type.

Can we get a linked table in Access to behave as it should? That is, I want my primary key, or any other integer field, to be just that. We declare it as so in Oracle, but Access seems to refuse to get along with Oracle. It either treats the Oracle data type INTEGER as text, or as NUMERIC but as a decimal, not an integer....

Help!

TIA,

Jeff

 

[PHV]

INTEGER(x,y)
What is the meaning of x and y for Oracle ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[iamareplicant]

x I beleive is the precision argument, and y is the scale:

http://www.ss64.com/orasyntax/datatypes.html

 

[PHV]

So, the access data type for such field is DECIMAL

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[iamareplicant]

PHV,

are you saying that Orcaled INTEGER = Access DECIMAL?

If so, what is the Oracle data type to get Access NUMERIC integer?

Jeff

 

[iamareplicant]

oops, I should have wrote:

Oracle NUMERIC = Access DECIMAL

 

[PHV]

I don't know Oracle but usually SMALLINT and INTEGER are numeric integral types of data.
And yes, I said that Oracle NUMERIC seems to be Access DECIMAL.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cmmrfrds]

This link shows the mapping of Oracle data types to Access.

http://support.microsoft.com/?kbid=104977

 

[iamareplicant]

Thank you so much for that link cmmrfrds. This issue has been driving me nuts and that link confirms that I am doing the right thing. Just what I needed.

Jeff