Question re: exporting an nsf file into ms access or excel?

HCL Domino Domino Forum
1

Hi there,

Just curious if there is a way to export an .nsf file into ms access or ms excel?

2

Subject: Question re: exporting an nsf file into ms access or excel?

I assume you mean the documents in the .nsf file… The answer is yes. The easiest way is to create a view and export it to a 123 .WK3 file which Excel can open. There are many other options available using programming methods.

3

Subject: Question re: exporting an nsf file into ms access or excel?

I would use notessqlhttp://www-142.ibm.com/software/sw-lotus/products/product4.nsf/wdocs/notessqlhome

4

Subject: RE: Question re: exporting an nsf file into ms access or excel?

Thanks to all for the information! Much Appreciated!

5

Subject: Question re: exporting an nsf file into ms access or excel?

Not a complete file, as such, but you can export views of documents, or indivdual documents to Excel and to flat text formats.

See under your Lotus Notes client’s File - Export menu for options to export the current open view to Lotus 1-2-3 format, which can be loaded directly into Excel, or to other file formats.

Note that there is a limit on the number of 8192? rows in a Lotus 1-2-3 spreadsheet.

Through LotusScript code you can perform more complex exports. See the link on this page to “Forum FAQs…FAQ of FAQs” and look for Export.