Re: Oracle datatypes in Access

>One of our customers is attaching Oracle tables into his Access
>application but some of the NUMBER fileds are coming through as type
>Text.
>
>It seems that it depends on thenumber of digits in the NUMBER field.
>
>Has anyone come across this or does anyone have any workaround
>suggestions?
>
>

Here is the deal,

ORACLE                 ACCESS
number 1-4,0           integer
number 5-9,0           Long Integer
number 10-15,0      double
number 16-38,0       text

A work around is to use something like CLNG in an expression in ACCESS Received on Tue Nov 11 1997 - 00:00:00 CET