Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Exporting large fields from Lotus approach to 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Data exported from Lotus approach to excel how do I show it in a u Martin Heathcote Excel Discussion (Misc queries) 0 July 7th 08 10:06 AM
Exporting Lotus 123 into Excel Work Book? simond Excel Discussion (Misc queries) 1 March 11th 07 09:14 AM
How do I export Lotus Approach files into an Excel spreadsheet? LEWOLF New Users to Excel 1 March 20th 06 05:19 PM
exporting excel to csv large fields save as "####" zzapper Excel Discussion (Misc queries) 6 June 25th 05 09:25 PM
Using EXCEL 2003 how do I open a Lotus Approach 9.5 database? JHB Excel Worksheet Functions 4 February 3rd 05 10:43 PM


All times are GMT +1. The time now is 01:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"