How to export data from notes to Excel using notesSQL

HCL Domino Domino Forum
1

How to export data from notes to Excel using notesSQL

Pls Guide me anybody through coding

2

Subject: How to export data from notes to Excel using notesSQL

Use the NotesSQL Samples Kit located at http://www14.software.ibm.com/webapp/download/search.jsp?v=11&lang=en&cc=us&realm=tnb&q=NotesSQL

It gives you examples for Access and VB’s ADO (which you should be able to use in Excel)

Ron

3

Subject: RE: How to export data from notes to Excel using notesSQL

If you’d like to consider an export tool that has been developed specifically for Lotus Notes/Domino we have one written totally in standard LotusScript which enables you to export Lotus Notes/Domino data from any database/view in the following formats:* CSV (comma)

  • Fixed Width

  • HTML

  • Tab Delimited

  • Microsoft Access

  • Micosfoft Excel

  • Microsoft Word

  • PDF

  • XML

It fully supports exporting using Notes clients and web browsers.

For more information and to try it out click the following link:

Regards,

Alex