Import from Excel into Access

hushens10

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!

Aug 20 '08 #1

NeoPa

I've changed the title to something more sensible (conforms to site rules).

It's hard to answer the question though in this form.

What have you tried?

Is all the data in the same format?

Does the data include something that identifies its source (If the data comes from workbook A & sheet 3 are A & 3 in the data anywhere)?

Aug 20 '08 #2

NeoPa

The simplest concept (assuming no complications) is to copy and paste the data in after preparing the table that you want to store it all in.

Aug 20 '08 #3