Re: Exporting data from Lotus Approach to MS Excel

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...@xxxxxxxxxxx wrote:
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

.

Relevant Pages