Open an Access database on Linux

[appel]

I need to convert a Access database to a MySQL database. Well, not just convert … we have a greater (MySQL) database with a structure in it. The Access database contains addresses we want to fit into the structure of the MySQL database. So, my idea was to write a piece of PHP code that opens the Access database, retrieve the records and put them (in a specific way) in the MySQL database.
I’m running PHP3 on Linux and I need to open that Access database, while it’s on Linux. That’s the biggest problem, I think.

So, is it possible to open an Access database with PHP while it’s stored on Linux?

 

[sophisticate]

Okay. It is possible, but it may cost you a few dollars and a recompile

You'll need to compile PHP with ODBC capabilities. In order to do this, you'll need an ODBC driver manager installed (

http://www.iodbc.org).

Then you'll need drivers for an Access database (

http://www.openlink.co.uk).

From there, all you'll do is setup a DSN to the Access file, much like you do on an NT system when accessing the database from ASP, and use the PHP ODBC functions to pull your data.

Sounds like fun, huh?

Best of luck.

brendanc@icehouse.net

 

[appeltje]

Well, I can't recompile PHP, it's not possible.

I've thought it over and I will try to export the access db to text and then import it with PHP. Hope that helps.

Thanks anyway!