Hi Guys,

I am trying to convert our Lotus Approach databases onto an Oracle
platform. To do this, I am exporting the data into an excel csv file
(using file-export data in lotus approach) and then using APEX to
create the Oracle tables based on the csv that I am uploading.

One problem that I am having is that when I am exporting large memo
fields from Approach to excel, the fields are being to truncated to
255 characters.

Can anyone please advise how I can get around this problem and export
the full value into the csv file please.

Many Thanks
Chris

As I remember Approach used the .dbf format. You could import those
directly into a number of environment, including MS Access, whence you
could export directly to Oracle.

Tim Mills-Groninger

On Jul 28, 6:27*am, christopherc... (AT) hotmail (DOT) com wrote:

As I remember Approach used the .dbf format. You could import those
directly into a number of environment, including MS Access, whence you
could export directly to Oracle.

Tim Mills-Groninger

On Jul 28, 6:27*am, christopherc... (AT) hotmail (DOT) com wrote:

As I remember Approach used the .dbf format. You could import those
directly into a number of environment, including MS Access, whence you
could export directly to Oracle.

Tim Mills-Groninger

On Jul 28, 6:27*am, christopherc... (AT) hotmail (DOT) com wrote: