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: Convert Tables - Access to Oracle

Re: Convert Tables - Access to Oracle

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Fri, 03 Dec 2004 22:16:38 GMT
Message-ID: <41b0e5a5.1306014159@localhost>


Check oracle site for 'migration' tools. I am not sure if they have one for Access.

On Fri, 3 Dec 2004 13:28:17 -0500, "Jason Gyetko" <jgyetko_at_epower-inc.com> wrote:

>Does anyone know of a good Access to Oracle conversion process or program?
>I tried Intelligent Converters - Access to Oracle v1.3, which converted all
>tables successfully, but I am having issues with the Number fields that were
>converted. When I link to the Oracle DB from Access, the Number fields are
>shown as Text instead of Number, but when I look at them in Oracle they are
>Number fields. The conversion made the Size property of the Number field
>38. If I change that to 0 my Access links are ok. Thanks.
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Fri Dec 03 2004 - 16:16:38 CST

Original text of this message

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