Thanks for the feedback and advice. You’ve confirmed what I suspected…that I would have to work directly in the database tables, and that it would entail programming competence slightly beyond my current level. I’ve been able to use VBA to retrieve data from PassPort tables without hurting myself. But I’ve always banged my shins when trying to get to, understand and open the blob files. I’ve never worked with Java or Unix.
To complete the story, the embedded images that I was trying to get to were generally raster files (opening with Imagenation Allview) or PDFs.
I use Excel (and its MS Query function) for my PassPort queries, simply recording a query, then manipulating the SQL string to introduce variables that a casual user can then manipulate from the spreadsheet. The Excel queries have become popular, here, as a quick, user-friendly alternative to Crystal Reports.
Thanks for the feedback and
Thanks for the feedback and advice. You’ve confirmed what I suspected…that I would have to work directly in the database tables, and that it would entail programming competence slightly beyond my current level. I’ve been able to use VBA to retrieve data from PassPort tables without hurting myself. But I’ve always banged my shins when trying to get to, understand and open the blob files. I’ve never worked with Java or Unix.
To complete the story, the embedded images that I was trying to get to were generally raster files (opening with Imagenation Allview) or PDFs.
I use Excel (and its MS Query function) for my PassPort queries, simply recording a query, then manipulating the SQL string to introduce variables that a casual user can then manipulate from the spreadsheet. The Excel queries have become popular, here, as a quick, user-friendly alternative to Crystal Reports.