Re: migrating access97 to oracle73 with many memos in one table

d_b,

It's been a long time, but under access 1.2 going to Oracle 7.3.4 on NT, I was able to move multiple memo fields by doing the following:

Manully create a table in Oracle using varchar2(512) or longer if you want for your memo fields. Do not exceed 2k on these fields. Once the tables have been created, start you access and create links to the oracle tables using your ODBC. Create a SQL script in access to insert all the records from the access tables to the linked Oracle tables.

Good luck.

M

d_b wrote in message <382EA9E7.7FB4C8EA_at_yahoo.de>...
>Hi there!
>
>Although I scaned this discussion group and the oracle one I don't have
>any idea to go on. My Access database has some tables with ten or more
>memo fields. I tried the Migration Tool from Oracle 73 but beside the
>point no data in this fields is longer than 512 bytes it crashes because
>"there can be only one long datatype per table".
>Using ODBC to connect to oracle and export the tables manually there is
>useless - same error.
>Does anyone have a good idea how I can get my data into oracle? The way
>may be strange, important is that it is working.
>
>Thanxs, D.
>
Received on Sun Nov 14 1999 - 08:09:26 CST