Linking mutliple excel worksheets to one access db

  • Thread starter Thread starter Prof. Rex Crick
  • Start date Start date
P

Prof. Rex Crick

Graduate teaching assistants use excel worksheets to
record grades for 12 different lab sections (=12
different worksheets) but we use just one access database
as an online database from which students in these labs
can go online and check their grades. I have had no
success in linking these 12 worksheets to the database.
Is this possible such that changes made to the worksheets
will then appear in the database? There must be an
easier method that importing all 12 worksheets each time
we record new grades.

Thanks
 
My advice would be to eliminate the Excell sheets altogether and build data
entry screens in Access so that everyone can enter the data "on line". Put
the mdb file on a network share (after splitting it into a Front End and
Back End) and then everyone will have access to it.

I typically import Excel spreadsheets, not link them. Others prefer linking.
You could code 12 Import routines of named ranges easily enough so you only
have to click a button to run them all.
Use transfer Spreadsheet for this.
 
Back
Top