[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: Excel to Access/Finding Aids
Hi!
I am assuming that you are just moving the data, and not all of the equations, etc. If this is true, you can
use the import wizard, and point it to the excel spreadsheet, as the source, and modify the fields to the
appropriate format. Another option, is to export your data from excel to a comma-delimited format, CSV, and
then import the data into access from that file. (If you are moving the equations, etc, I have not done this,
but I'm sure that if you use the wizard in access, if will do it's best to move these over for you. If not,
you can go into design view and set the equations, down at the bottom.) Let me know if you have more specific
questions, and I will help you if I can :)
--
Shannon Eric Peevey
Computer Systems Manager
Central Web Support
University of North Texas
speeves@unt.edu
940-369-8876
Amy Blaine wrote:
> I am in the process of converting our finding aid from Excel spreadsheets to tables in an Access database.
>
> Have any of you been through this process? Words of wisdom and warning would be appreciated.
>
> Sincerely,
>
> Amy
>
> Amy Blaine, MSLS
> Librarian
> Association of American Medical Colleges
> 2450 N Street, NW
> Washington, DC 20037
>
> Phone: (202) 862-6261
> Fax: (202) 862-6136
> http://www.aamc.org
>
> A posting from the Archives & Archivists LISTSERV List!
>
> To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
> In body of message: SUB ARCHIVES firstname lastname
> *or*: UNSUB ARCHIVES
> To post a message, send e-mail to archives@listserv.muohio.edu
>
> Or to do *anything* (and enjoy doing it!), use the web interface at
> http://listserv.muohio.edu/archives/archives.html
>
> Problems? Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>
A posting from the Archives & Archivists LISTSERV List!
To subscribe or unsubscribe, send e-mail to listserv@listserv.muohio.edu
In body of message: SUB ARCHIVES firstname lastname
*or*: UNSUB ARCHIVES
To post a message, send e-mail to archives@listserv.muohio.edu
Or to do *anything* (and enjoy doing it!), use the web interface at
http://listserv.muohio.edu/archives/archives.html
Problems? Send e-mail to Robert F Schmidt <rschmidt@lib.muohio.edu>