Re: Convert Access tables to Oracle

Hi,

[Quoted] When i have to import Access to Oracle , I use DTS (Microsoft Software ) which
is installed with The sql server client (you can do the same thing with Sql Server Entreprise Manager .
Be carrefull , sometimes , the data format memo is converted in long If you want to transform into char
Put in a PL/SQL bloc:

L_variable long
C_variable varchar2(4000)
C_variable :=substr(L_variable,1,4000)