Date: Wed, 24 Sep 1997 08:38:36 GMT
From: "Keith Renwick" <kdrenk@fs3.li.umist.ac.uk>
Subject: Re: Spreadsheet applications for subscription duplication

The idea of using a database to compare duplicated holdings in
various formats, etc. is a good one and Excel may well be the most
suitable form. Our experience of Access has been very good indeed. We
used it last year for a periodicals voting exercise and it has also
been used for stocktaking purposes with excellent results, roughly
four times faster than the previous manual method of operation.
Hope this is useful.

Keith D. Renwick,
Head of Technical Services & Administration,
UMIST Library & Information Service,
P.O.Box 88,
Manchester M60 1QD.
Tel : (44) 161-200 4940
Fax : (44) 161-200 4941
E-Mail : K.Renwick@umist.ac.uk

---------------
Liz Linton <melinton@ALISON.SBC.EDU> wrote:

> >Our library is embarking on a huge project to compare the duplication of
> >subscriptions between Searchbank, Wilson, our consortium and our current
> >subscriptions.  Has anyone done anything like this?  If so, could we see
> >how you did it, etc...?  We are looking at doing it on an Excel
> >spreadsheet.
>
> I've been using MS Works since 1993. I like it for the most part. I've also
> heard of people using Access with good results.
>
> Liz Linton
> Serials Librarian/Web Developer
> Sweet Briar College Library -- http://www.cochran.sbc.edu/frames.html
>
> 804-381-6315
> melinton@alison.sbc.edu
> Gifts of Speech: Women's Speeches
> >From Around the World -- http://gos.sbc.edu