Access is showing datatype as text ...why ?

[copernicus]

Hi,

I have an Oracle9i server.I am connecting

a) via Microsoft ODBC for oracle
b) via Oracle client :

I have a table in Oracle say customers(col1 number(26,6) is showing up in Access as text datatype.


How to fix this from client side,I mean how to make sure that this shows up in access as a "double" datatype rather than a "text" datatype.

Thanks,
copernicus

[KnooKie]

I guess Access just doesn't recognise the number(26,6) as a double. It probably doesn't have the precision that Oracle has so it uses the Text datatype as a default generic type.

You'll have to manually or code the change.