Re: [IUG] Excel files

[Yitzchak Schaffer <yitzchas at touro dot edu>]

I've also written fairly simple Visual Basic scripts in Excel to send 
MARC headers and preset fields to a text file, interspersed with data 
from the Excel cells.

We bought a collection of hundreds of manuscripts on microfilm, which 
included basic bib data printouts.  No records for this stuff existed.  
I just populated an Excel file with various fields, and cranked it 
through the macro.  Great if you have a lot of records, especially if 
you want to use a header template and insert e.g. 260|c values into the 
date fields of the 008.  Also if you need to manipulate the data in some 
scriptable way.


Yitzchak Schaffer
Systems Librarian
Touro College Libraries
33 West 23rd Street
New York, NY 10010
Tel (212) 463-0400 x230
Fax (212) 627-3197
yitzchas at touro dot edu


Finnerty, Ryan wrote:
> Hi Pamela,
>
>  
>
> I've done this several times with Excel files. Unfortunately I don't
> have the process documented but here it is in a nutshell:
>
>  
>
> Edit the Excel file so you put a column in front of every existing
> column. Put the appropriate MARC tag in each cell of the new columns.
> Save the Excel file as a tab delimited text file. Open it in Word and
> doing tons of find and replace passes, make it look like a MarcEdit text
> file. Open in MarcEdit and convert to Marc. Load into Millennium using
> Data Exchange
>
>  
>
>  
>
> Ryan J. Finnerty | Head, Database Management & NACO Coordinator
>
> UC San Diego Libraries | Metadata Services Department
>
> 9500 Gilman Drive 0175K | La Jolla, CA 92093
>
> T 858 822 3138 | F 858 822 0349
>
> rfinnerty at ucsd dot edu | libraries.ucsd.edu
>
>  
>
>  
>
>  
>
>  
>
>  
>
> -----Original Message-----
> From: innopac-bounces at innopacusers dot org
> [mailto:innopac-bounces at innopacusers dot org] On Behalf Of Smith, Pamela J.
> Sent: Friday, December 07, 2007 10:36 AM
> To: IUG INNOPAC List
> Subject: [IUG] Excel files
>
>  
>
> Is there any way to import an Excel text file into Millennium? I'm
>
> looking for a way to create brief records in the system from an Excel
>
> file. Probably not possible, but if anyone would know it would be the
>
> list members. Thanks
>
>  
>
> Pamela J. Smith
>
> Technical Services Manager
>
> Albuquerque/Bernalillo County Library System
>
> 501 Copper Avenue NW
>
> Albuquerque, NM 87102
>
> psmith at cabq dot gov
>
> (505)768-5137
>
> (505)768-5116 fax
>
>  
>
>  
>
>  
>
> --- StripMime Report -- processed MIME parts ---
>
> multipart/alternative
>
>   text/plain (text body -- kept)
>
>   text/html
>
> ---
>
> --
>
> This message was distributed through the Innovative Users Group INNOPAC
> list
>
> Public replies:  INNOPAC at innopacusers dot org
>
> Update your subscription options:
> http://innopacusers.org/mailman/listinfo/innopac
>
>
>
> --- StripMime Report -- processed MIME parts ---
> multipart/alternative
>   text/plain (text body -- kept)
>   text/html
> ---
> --
> This message was distributed through the Innovative Users Group INNOPAC list
> Public replies:  INNOPAC at innopacusers dot org
> Update your subscription options: http://innopacusers.org/mailman/listinfo/innopac
>   


--- StripMime Report -- processed MIME parts ---
multipart/alternative
 text/plain (text body -- kept)
 text/html
---