Greetings,
I would go with the Lotus Script instead of the ODBC driver. Here is
some sample code - this will use Lotus Script which you can add DAO code
to read the data from the Lotus Script - make a reference to the Notes
Library in Tools/References - also - you can use early binding with R5
dim sess as New Notes.Session - way better than late binding):
Dim session As Object 'notes session
Dim db As Object 'notes database
Dim view As Object 'notes view
Dim searchview As Object 'notes search results
Dim doc As Object 'notes document
Dim DocCount As Long
Dim ViewStr As String
Dim testvar As string
ViewStr = "3. R&D\By Period"
Set session = CreateObject("Notes.NotesSession")
Set db = session.GETDATABASE("SERVERNAME",
"C:\someDir\yourNotesNsf.nsf")
Set view = db.GetView("View1")
Set doc = view.getfirstdocument
testvar = doc.getitemvalue("fld1")
then you can loop using the GetNextDocument object
Rich
*** Sent via Developersdex
http://www.developersdex.com ***