Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Number Width Issue when importing Oracle Data into ms Access
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