Hi all: So the pressure is on to import a bunch of MARC records (in Word) into our shiny new CMS (EMu). I need to convert the MARC Word document into some format that I can then use to recode the MARC tags into EMu-speak. I've done this with our old records using Excel, and would like to use Excel again to work with the MARC records (yes, I recognize that this may mean that I'll have potentially 1000 or so columns to deal with). And our archivist is quite against Excel, and says that he can only get the MARC records in Word. I don't know if this is true or not, but I'm pressuring the powers that be to see if I can at least get the records in CSV or delimited text. However, I'm working with the assumption that Word is what I've got to work with.
Unfortunately, all of our MARC records are in Word, and I can't get Word to break out the columns correctly (it wants to create a lot of rows instead of columns). I did find this older program, which makes me hopeful that this process won't be as complicated as I anticipate: MARC RTP http://rossjohnson.homemail.com.au/MARCRTP/ But I'm wondering if anyone else here has had to deal with this problem and what you did to solve it. Did you have a software package that helped you? Thanks in advance everyone! Perian Sully Collection Database & Records Administrator Judah L. Magnes Museum 2911 Russell St. Berkeley, CA 94705 510-549-6950 x 335 http://www.magnes.org Contributor, http://www.musematic.org