Willis, Frank A wrote:
Is there any way to use the Perl DBI and SQL to open an .odb file?
This lists a number of possibilities:
http://filext.com/detaillist.php?extdetail=odb&Submit3=Go%21
The most likely one is OpenOffice.Org Database. If so, I'd check their site to find the format, it may be some flavor of XML. Or, I think OO.O has ways to export their format directly to CSV. If it does turn out to be OpenOffice, I'd be interested to hear what you find out.
The second part of that can be done by DBD::CSV or Text::CSV_XS if there's no direct CSV export from whatever program produced the original file.I am trying to open the .odb file, read it, and parse it out to a .csv file.
-- Jeff