[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