Good ideas and samples needed!

[dadazhu]

Hi,

Is there anyone can help me out? Only one weeks left!

I am doing a school reporting project which will import student data from a Ms EXCEL spreadsheet to access and allow user to add more data in, at the end generate a student report.

The solution I am thinking is,
I have to import whole school student data from one spreadsheet, and separate them base on classes, every class contains its students. One teacher can only handle one class students as one supervisor can handle five class students.
Also, the teachers are allow to bring his/her class data back home to process report at PC, and come back with updated data.

I don't know how to import data from excel to access to create things like that. And I am thinking to use excel to be part of database in my program, is this possible?
I very need any good idea and prefer some samples regarding to imporing data from excel to access.

Any suggestion and help appreciated in advance!

dadazhu