Good ideas and samples needed!

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:confused: :confused:

http://www.vbforums.com/showthread.p...CEL+AND+ACCESS

Probably some others within this lot too :
http://www.vbforums.com/search.php?s...der=descending

Hi dadazhu - taken me a little while to do this sample I admit - I'll explain why in the following post, but please try this sample first to see if it works on your PC - please let me know if it does or doesn't as I'd be very interested.

Cheers,
Alex :)

Okay, I had a loop set up (you can see wheree I've changed the coding in this one as I surrounded it with "##############" symbols), which uses the RECORDCOUNT property of DAO to tell me "okay, there are x number of rows found in the database table".
This one's got an extra loop set up to let me know this number, and doesn't use the recordcount property so it'll work if the one above is ~£@*/!!! ;)

Thank you very much ! alex_read

No problem, thanks. :)
I've just updated the first one which'll save you some lines of code now it's working.

Thanks to Jamie, apparently you have to call the recordset.movelast function just before you call on the recordcount property to get this to return the proper number. :cool: