Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Number Width Issue when importing Oracle Data into ms Access

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

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 04 Dec 2002 22:53:33 +0100
Message-ID: <h8usuuccvd07l1fo3vlthf36t6p7r2ru2f@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 - 15:53:33 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US