Exporting data from Lotus Approach to MS Excel

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

  • Re: Exporting data from Lotus Approach to MS Excel
    ... I am trying to convert our Lotus Approach databases onto an Oracle ... I am exporting the data into an excel csv file ... (using file-export data in lotus approach) ... the full value into the csv file please. ...
    (comp.databases)
  • Exporting large fields from Lotus approach to Excel
    ... I am trying to convert our Lotus Approach databases onto an Oracle ... I am exporting the data into an excel csv file ... One problem that I am having is that when I am exporting large memo ...
    (microsoft.public.excel.misc)
  • Re: Exporting Data to a CSV Text file
    ... to a CSV file, most of the information will come from existing field ... and make sure it gets sorted to the top before exporting to the ... In windows: copy header.txt + export.csv joinedfile.abc will get the ... You can automate this from within Filemaker; have the script pause a ...
    (comp.databases.filemaker)
  • Exported UTF-8 data in CSV file not working as expected
    ... Exported UTF-8 data in CSV file not working as expected. ... i am exporting the utf-8data from my jsp code into ... formate of the CSV file data get changed after exporting the data. ... saving in correct form but when i use websphere application server the ...
    (comp.lang.java.programmer)
  • exports contact fields mapping incorrectly
    ... I tried exporting to .xls and .csv files from Outlook so I could edit the fields in bulk in Excel. ... when I load them into excel there is no fullname field and the first and last names are filled in! ... when exporting Contacts from Outlook to an Excel or .csv file I have several ...
    (microsoft.public.outlook.contacts)