Re: Access 97 problem zzz

From: Norbert Möndjen <Norbert.Moendjen_at_t-online.de>
Date: 1998/08/11
Message-ID: <6qos1o$9mm$1_at_news01.btx.dtag.de>#1/1


Hello,

1.) If the numeric field is a floatingpoint look for the decimal delimiters.

      Maybe you use a "." and oracle a "," or vice versa. 2.) If it is declared as text in Oracle you need a query to transform it.

Ciao Nobbe

kinny lanadjaja schrieb in Nachricht <35CFAFDC.25F3C2B4_at_njs.com.hk>...
> Can anybody please help me to solve Access 97 problem? Here is the
>situation. I tried to link table data from Oracle 8.0.4 using Oracle
>ODBC 8.0.4. However, the number field in the linked Oracle table is
>treated as text field in Access 97 automatically. This is very
>troublesome. I used get external data and choose ODBC data source.
>Please suggest me any solution. Thank you.
>
Received on Tue Aug 11 1998 - 00:00:00 CEST

Original text of this message