Re: Exporting Access data/import to Oracle

From: Bob Nightingale <rnightingale_at_comshare.com>
Date: Tue, 30 Jun 1998 15:40:47 -0500
Message-ID: <6nbijr$63m$1@inet-prime.comshare.com>

If your target is Varchar2(8), then you'll have to run an update on each of the columns with the function rtrim:

update newtable set col1=rtrim(col1);

rtrim defaults to blanks. It'll remove those dangle blanks. --Bob.

calberto_at_my-dejanews.com wrote in message <6n8raq$shq$1_at_nnrp1.dejanews.com>...
> Hi all!
>
> I have some problems to transfer data from Sybase to Oracle. I used
Access
>like an interface to do this. The first is :
>
>1) A char(8) column in my Sybase's table which has data with 6 characters
only
>is generated with the data followed with blank spaces to Oracle. It seems
that
>Access doesn't have datatype char and therefore it converts to the maximum
>length of the column;
Received on Tue Jun 30 1998 - 15:40:47 CDT