?
Solved

Exporting view/report to Excel

Posted on 2003-04-01
7
Medium Priority
?
192 Views
Last Modified: 2013-12-18
I am trying to export a view from a notes database into an excel spreadsheet. However, the problem I am having is the text fields in excel are only importing and displaying the first 255 characters from the lotus notes field and then it gets truncated. How can I solve this? I need the whole text field to be displayed in the spreadhseet, regardless of length.
Thanks.
0
Comment
Question by:lauren4110
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
7 Comments
 
LVL 4

Expert Comment

by:Stan Reeser
ID: 8247788
Unfortunately that is a fundamental restiction in using i/e with spreadsheets.   You can use Tabular text though and then bring it into your spreadsheet.
0
 
LVL 4

Expert Comment

by:Stan Reeser
ID: 8247789
Unfortunately that is a fundamental restiction in using i/e with spreadsheets.   You can use Tabular text though and then bring it into your spreadsheet.
0
 
LVL 2

Expert Comment

by:stltt
ID: 8248082
Try exporting in 123 format - and open this in Excel ??
0
 
LVL 4

Accepted Solution

by:
Stan Reeser earned 400 total points
ID: 8248228
Actually, the only way exporting a spreadsheet can be done is by saving as a 123 and then opening in excel, but the underlying issue is with 123 and the cells can only hold 255 characters (sometimes less depending on the 'kind' of characters).  One little tip saving as .wk4 when you export makes the file more compatible with Excel (gets rid of the black blocks).  Tabular text will work but one thing you have to remember is that the columns in notes need to be as wide as the largest entry and you can't wrap lines (they will show up on a separate row in the spreadsheet).  
0
 
LVL 4

Expert Comment

by:Stan Reeser
ID: 8248262
You could also try a package from granite software called zMerge... been a while since I've used it but it was a really good tool then.
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
Suggested Courses

741 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question