Re: Number Width Issue when importing Oracle Data into ms Access

From: Ronnie Yours <ronnie_yours_at_yahoo.com>
Date: Wed, 4 Dec 2002 17:14:24 -0500
Message-ID: <aslute$mma$1@ngspool-d02.news.aol.com>

Hi Sybrand,

I have made the entry "set numwidth 15" in the glogin.sql file and importing the data directly into access from oracle using the odbc link but still the data is getting imported in the format 6.080540005E+11.....

After making the change in the glogin.sql file I see the data correctly from the sqlplus but MS Access import is still not working the way I want it to and that is the data format should be 608054000500.

is there any odbc setting which needs to be tweaked here??????

Please suggest.

Thanks

"Sybrand Bakker" <gooiditweg_at_sybrandb.demon.nl> wrote in message news:h8usuuccvd07l1fo3vlthf36t6p7r2ru2f_at_4ax.com...
> On Wed, 4 Dec 2002 15:08:48 -0500, "Ronnie Yours"
> <ronnie_yours_at_yahoo.com> wrote:
>
> >
> >Now the problem is that the data is being imported as
>
>
> You can directly import into Access using ODBC. No need for
> intermediate text files.
>
> You can also include set numwidth 15 in your login.sql
>
> But of course using an ODBC connection would be the least cumbersome
> solution.
>
>
> Sybrand Bakker, Senior Oracle DBA
>
> To reply remove -verwijderdit from my e-mail address
Received on Wed Dec 04 2002 - 16:14:24 CST