Re: Converting(Access 97 to Oracle)

Hi Sybrand,
I saw your post and had a follow up question. I am migratin an Access database to Oracle, but Oracle seems to 'not like' the MS Access memo field. I can migrate everything using MS Access via linked tables to the Oracle database and ODBC. But it always fails on memo fields. Do you have any tips to get around this? Thanks much in advance.

...Brad

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:953836500.8260.3.pluto.d4ee154e_at_news.demon.nl...
> There is an Acess Migration Wizard in Oracle but that doesn't seem to work
> without problems.
> The other solution is to create an ODBC DSN to the Oracle database and
> export all your tables to the Oracle Database using Access.
> Warning: All your tablenames need to be in uppercase and without special
> characters. ODBC doesn't convert this automatically and Oracle requires
you
> to enclose all object names with special characters (lower case, spaces
etc)
> in double quotes.
>
> Regards,
>
> Sybrand Bakker, Oracle DBA
>
> <chadwick29_at_my-deja.com> wrote in message
> news:8bddca$upr$1_at_nnrp1.deja.com...
> > Is there any way of converting from Access 97 to Oracle and keeping all
> > data intact? I want to do this in the future and would like any helpful
> > input on how I might do this and problems I may encounter. Anything
> > would help just to give me an idea of what to expect. Thank You.
> >
> > Chad Wentworth
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
>
Received on Fri Mar 24 2000 - 19:11:24 CST