We have done this using MARConvert when we needed to import records for our archival and special collections into TMS. The application is configurable to allow you to parse or suppress subfields in different ways so that the resulting data is much easier to work with. If your source format is Word, I'm not quite sure how/if the records could be ingested without first transforming them somehow, but Stephen Toney at Systems Planning might have some ideas for you. http://www.systemsplanning.com/marconvert/
Good luck, Deb Deborah Lenert Digital Projects Specialist Getty Research Institute Standards & Digital Resource Mgt. Dept. phone: (310) 440-7351/ fax: (310) 440-7780 dlenert at getty.edu >>> "Perian Sully" <psully at magnes.org> 3/21/2007 1:13 PM >>> 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 _______________________________________________ You are currently subscribed to mcn-l, the listserv of the Museum Computer Network (http://www.mcn.edu) To post to this list, send messages to: mcn-l at mcn.edu To unsubscribe or change mcn-l delivery options visit: http://toronto.mediatrope.com/mailman/listinfo/mcn-l