Is it possible to use MS Access as a db with PHP?

If so, how?

If not, is there a way to convert (for free without buying a program) MS Access file to MySQL?

Thanks for your efforts

Recommended Answers

All 3 Replies

dunno about a free (tool) to do this, but if you can export your database as sql.. (not sure if you can do this in access, i know you can in that other cheap ms database [sql server]).. but if you can do this, then just export the data into some csv format and import that into cool db of choice!

from the searching i have done it looks like you can convert from access to mysql i have found a migration thing on the mysql website i dont know if its free but if you do a search on google for a access to mysql converter you will find alot of options here are a few i found :)
http://www.fonlow.com/zijianhuang/dbconverter/
the one from the mysql db here : http://dev.mysql.com/doc/migration-toolkit/en/mysql-migration-toolkit-indepth-sourcedb-access.html

and if you really want to use access which most people will say dont. there are ways just do a quick google search for php + ms access and you will find a few options :) good luck

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.