[WEB4LIB] excel to access
Michael Sauers
msauers at bcr.org
Wed Jun 14 14:25:44 EDT 2000
> Forgive me for what is probably a very basic question not
> directly dealing with websites but I believe this list can help
> me. If you have a periodicals title/holdings list in excel, how
> can you transfer that to an access database? Do you need to
> create an access database first that has similar fields? I
> appreciate your input. thanks.
No. You can use Access' import function (may be called "get external data"
depending on the version) to import an Excel spreadsheet and create a new
database based on that data.
---------------------------------------------------------------------
Michael Sauers, Internet Trainer
Bibliographical Center for Research (BCR)
Aurora, CO :: msauers at bcr.org :: http://www.bcr.org/~msauers/
The WWW Library Directory is @ http://www.webpan.com/msauers/libdir/
Buy books, music or videos? http://www.evenbetter.com/?partner=1307
Opinions expressed are my own unless otherwise noted.
---------------------------------------------------------------------
More information about the Web4lib
mailing list