.mdb to MySQL

[NZ_Kiwis]

I'm on a unix server and i'm sending data from my Visual Basic application to a .mdb. Want to want to do is write a PHP code which will look into the .mdb and then get all new information and add it to my MySQL database then update each row and set the "read" field to 1.

1/ Firstly can this be done using PHP on a unix server
2/ Any ideas how to connect to .mdb??

[groovepapa]

Could prove to be trick if you only have access to a Linux machine. But, there's mdbtools (http://pecl.php.net/package/mdbtools) for PHP. Other than that, you may have to use ODBC, but that might mean you'll need to run the PHP script on a Windows machine? (http://phplens.com/phpeverywhere/node/view/9)

I don't know for sure - haven't done enough with ODBC on Linux. But hopefully those links can get you started on the right path.