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
Last edited by dadazhu; Oct 24th, 2001 at 02:59 AM.
Please rate this post if it was useful for you!
Please try to search before creating a new post,
Please format code using [ code ][ /code ], and
Post sample code, error details & problem details
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
Last edited by alex_read; Oct 26th, 2001 at 05:40 AM.
Please rate this post if it was useful for you!
Please try to search before creating a new post,
Please format code using [ code ][ /code ], and
Post sample code, error details & problem details
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 ~£@*/!!!
Please rate this post if it was useful for you!
Please try to search before creating a new post,
Please format code using [ code ][ /code ], and
Post sample code, error details & problem details
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.
Please rate this post if it was useful for you!
Please try to search before creating a new post,
Please format code using [ code ][ /code ], and
Post sample code, error details & problem details
Good ideas and samples needed!
Reply With Quote
