Java Programming

I'm still new to Java and I need some advice on the best approach to take for my situation. I'm building a desktop application where I'm working with Lotus Notes and I'm iterating through a document collection. For each document I want to grab certain field values. I would like to be able to put these values in some sort of resultset where I can perform various sql queries against it then save the results to a spreadsheet or somehow pass the data to a report. The idea I've come up with so far is to use a vector or some sort of list but it sounds like the query part of this solution will be rather tedious and I'm thinking I would have to iterate through the vector/list at least 2 times in order to produce my groupings.
I also read about storing the records in an xml file then using xquery to query that file. I'm not opposed to this route but I have absolutely no experience creating xml files and have not found a very good tutorial. The xquery part looks pretty easy though.
I'm currently working with about 70k records and expect to be close to 100k by the end of the year (the new year starts over). Not sure if that's large or small for any of the mentioned technologies.
IBM no longer supports a jdbc driver for Notes (which apparently was just a wrapper around the odbc driver) and I've had poor success using the ODBC driver, that's why I've gone the route of iterating through the collection. I also don't want to store the records temporarily in a database just to be able to get them back out.
Thanks, Bill