Access Naive - Help Needed
I am using Access 2003 and Excel 2003. My goal is to create a database for a school where each student's testing information can be stored and organized so that it can be pulled. Each teacher currently has their own Excel file, into which they have entered their student's data. However, for the purposes of other departments, they would like a database file where information can be culled and queries can be run (thus the need for Access).
I have multiple excel files, each with multiple worksheets. I would like to create an Access database using the information in the various Excel files (all of the files have the same column headings in each of the worksheet.. How do I make this happen? I am sure there is an easier way than I am trying. I do not know technical computer language, but I can follow directions, so ANY help would be appreciated.
Is there a way for multiple worksheet's and multiple file's data to be imported into an Access database?
Thank you!
|