|
Ok, here's a real doozy. I work for a privately owned daycare center doing general tech support around the center. I'm also starting to develope their website. I have much experience in both PHP and MYSQL. But I've never done this before. Ok, here goes:
They have 2 databases updated every now and then. 1 for clients, 1 for employees. Then, they have the punch in/out databases that are created once a month (e.g. 0804.mdb , 0904.mdb) but they are updated daily with the times the parents/employees are clocked in and out. The software they use was custom made to fit their needs. So uploading databases wasn't originally an option. So my first problem is, how can I upload these automatically, say at 7:00pm (an hour after they close). Second, how can I take the Access database files, and be able to read them with PHP OR convert them into MYSQL automatically. I want to be able to show client/employee information and be able to show the times both clocked in and clocked out online instead of only on their computers. Anybody have any idea on how to go about doing this?
|