Importing Lotus notes address book into EXCEL


G

Guest

I attempted to accomplish the above task by exporting Lotus Notes data to a
CSV file and importing to xl. My problem is that some of the data does not
import as one record one line, it wraps to two lines which causes data to be
in the wrong columns. I have tried the same process with MS Outlook without a
problem.

Is this a common problem related to Lotus Notes, and is there a way to fix
it? I checked the Lotus Notes database and the data is in the proper fields.
 
Ad

Advertisements

P

Pete_UK

Perhaps you have some spurious characters in there which are
interpreted as Line Feeds (or end of record). Have you tried opening
it with Notepad? Adjust the margins and set a non-proportional font
(eg Courier), and you should be able to see the offending records
quite easily if it is down to line-feed characters.

If you don't have too many, you can manually delete the line breaks in
Notepad and then save it back, so that you could then import it into
Excel once more.

Hope this helps.

Pete
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top