Quote:
Originally Posted by Doitsu
I'd try to open the .mdb file with Excel or write a VB macro for Access that exports all pages along with the image references in an easy to handle output format.
|
Just an update on this.
SNP itself just seems to be a Microsoft proprietary format designed to compete along the lines of PDF. I would avoid working backwards from SNP at all costs.
Me and EdK have done some communications over email. He was able to export the entire database as an Excel spreadsheet.
From there, we were able to pull out the relevant text columns. It looked to be a form of rough HTML plopped into the cells:
Quote:
<div align=center><font size=7><strong>PREFACE</strong></font> </div>_x000D_
_x000D_
<div> </div>_x000D_
_x000D_
<div><font size=3><strong>"</strong></font><font face="Lucida Calligraphy"_x000D_
size=3><strong><u>Bonzer</u></strong></font><font size=3><strong>" (definition, Macquarie Dictionary, 1985) - <em>/'bonza/</em>, adj. &n bsp; Colloq. Excellent, attractive, pleasing. Also, bonza, boshter"</strong></font></div>
|
But, with a little bit of elbow grease, you could export the cells and regex this into some clean/proper XHTML. Still would require a lot of manpower to rereplicate everything wanted (headings, captions, images, etc. etc.). But at least all of the text transferred to the spreadsheet fine.