Exporting data from Lotus Approach to MS Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

christophercash@hotmail.com - 28 Jul 2008 12:27 GMT

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

Reply to this Message

Tim Mills-Groninger - 31 Jul 2008 20:53 GMT

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

> Hi Guys,
>
[quoted text clipped - 12 lines]
> Many Thanks
> Chris

Reply to this Message