-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Import Lotus Notes database into Excel?
- Thread starter c_hickie
- Start date
Never used Lotus Notes, so I don't know the structure, but... many programs can be persuaded to spit out something employing a commonly-used file structure (dBase) or a generic one (csv). Try matching your export (Lotus) with your import (Excel) capabilities.
Good luck.
Good luck.
Upvote
0
Never used Lotus Notes, so I don't know the structure, but... many programs can be persuaded to spit out something employing a commonly-used file structure (dBase) or a generic one (csv). Try matching your export (Lotus) with your import (Excel) capabilities.
Good luck.
Good luck.
Upvote
0
Never used Lotus Notes, so I don't know the structure, but... many programs can be persuaded to spit out something employing a commonly-used file structure (dBase) or a generic one (csv). Try matching your export (Lotus) with your import (Excel) capabilities.
Good luck.
Good luck.
Upvote
0
XL-Dennis
Well-known Member
- Joined
- Jul 27, 2002
- Messages
- 1,920
It´s not an easy task because it´s subject to how the database is built-up and what kind of documents are stored in the database.
One possibly solution is to open the database in Lotus Notes, choose the command Files | Export and save it in the format "Tabular Text" (fixed widht).
Open it in XL and run the "Text to column-guide"
Good luck,
Dennis
Upvote
0
That worked great using the tabular text format. It may not have worked if I didn't have a program called Monarch. I was able to export it and open it in Monarch and manipulate it all over then finally send to Excel where it is needed. Thanks!!
Upvote
0
Similar threads
- Question
