He Perian, Without knowing much about MARC, or knowing the structure of the records as held in Word, I'm not sure if this is any good, but recently when trying to get some tabulated Word content into XML I cut-n-pasted the table into Excel and then mapped the columns onto a schema of my choice (via Data: XML: XML map properties). It's perhaps limited, but just might work for you...if the Word documents at least hold the MARC info in tables.
Cheers, Jeremy Jeremy Ottevanger Web Developer, Museum Systems Team Museum of London Group 46 Eagle Wharf Road London. N1 7ED Tel: 020 7410 2207 Fax: 020 7600 1058 Email: jottevanger at museumoflondon.org.uk www.museumoflondon.org.uk Museum of London is changing; our lower galleries will be closed while they undergo a major new development. Visit www.museumoflondon.org.uk to find out more. London's Burning - explore how the Great Fire of London shaped the city we see today www.museumoflondon.org.uk/londonsburning -----Original Message----- From: mcn-l-bounces at mcn.edu [mailto:mcn-l-boun...@mcn.edu] On Behalf Of Perian Sully Sent: 21 March 2007 20:13 To: 'Museum Computer Network Listserv' Subject: [MCN-L] MARC record conversion into Excel or CSV? 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
