I have loaded the Notes Sql driver. I conntected to a notes 6 discussion database on the server. Since the Discussion body could be as much as 5 pages, I set the max length of text fields to 9999, max length of rich text fields to 9999. I opened Access XP and linked to the ODBC connection. My problem is that I can only get 2 pages of data from the body field. Is there a limit? How can I get this data exported?thanks
Subject: Notes SQL 3.02.2003 1112
Use LotusScript and export via a custom LotusScript agent. You can use the getformattedtext of the NotesRichTextItem class and export that to a file format of your liking. It think it would be difficult to use Notes SQL drive because it was not antcipating that much data within one field.
HTH