Q 177: Is there a compilation somewhere of all the ways for archivists to get arcane casters' spells (particularly wizard/sorcerer) into their prayerbooks?
No, but it's been said in a few threads. Generally, step 1 is you must prove the spell exists as a divine spell. There's a Cleric variant in one of the Dragon mags that gets any Wiz/Sorc spell up to 8th level, there's the Hexer PrC (3.0) which is enterable by Clerics and adds any Wizard/Sorc spell to your spell list as a divine spell, there's domains, there's Shujenjas, there's the Favored Soul variant in Dragon Magic that gives any Wizard/Sorc spell up to 6th level to your list, and there's the Divine Magician variant that gives any Wiz/Sorc spell of one of a few schools to Clerics. Between all that, you can get all of them.
There's also Divine Bards which gets that list.
Really, the only spells you can't get on your list are Greater Harm (Dread Necromancer 9, it's a useless spell as it's worse than Harm but higher level), the Trapsmith list (you get all the spells, but not of such low levels), and the Death Master's Animate Dead (it's 2nd level, best you can do is 3rd). Possibly there's also some Wu Jen spells you can't get, but all the good ones are in domains anyway I think (Giant Size is in Hero Domain, for instance).
Step 2 is to then research the spell... researching a copy of any existing spell takes 1 day and a small amount of money. Or you can have a Warlock make a scroll of that spell, and write it in that way.
JaronK