Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Export tools? Notes to excel/access
- Thread starter Paulie
- Start date
No application as such, but I have found that creating a simple lotusscript program to work just as well. By using the NotesView class, a loop can be set to cycle through all documents and print them to a nominated text file. By using additional commas and line feed characters, you can build a file that can be opened in excel.
You could also download the NotesSQL ODBC driver and perform the required SQL actions using MS Query in Excel or link the tables in Access. This may prove worthwhile, but you won't have instant results.
If you take this method then each view will effectively be a 'table'. Therefore if you only want to see specific documents, refine you view contents before using the ODBC connection.
Hope this helps Phooey
Andrew.j.harrison@capgemini.co.uk
Otherwise known as Windy Bottom.
If you take this method then each view will effectively be a 'table'. Therefore if you only want to see specific documents, refine you view contents before using the ODBC connection.
Hope this helps Phooey
Andrew.j.harrison@capgemini.co.uk
Otherwise known as Windy Bottom.
- Status