• Registered: 2009-01-26
  • Posts: 171

Topic: How can PHP access data form “MS Access”

How can PHP access data form “MS Access”
Hi everyone
I have a list of teacher in MS Access with all of its attendance record, salary, contact info and so.
I want to make a form online that each one should login to see their record.
Can PHP / MySQL take record form “MS Access” files?
Or
Is there any way to import “MS access” tables to MySQL?
Regards

  • Registered: 2009-10-23
  • Posts: 6

Re: How can PHP access data form “MS Access”

hi,

You can use ODBC to connect to MS Access Database or You can try MySQL Migration Toolkit  (http://dev.mysql.com/downloads/gui-tools/5.0.html) to convert MS Access to MySQL. If you already have MySQL server installed you can transfer data directly to MySQL database or  create an sql file which can be imported to MySQL database.