RE: [PHP] access database on linux

Ajdin, ODBC will allow you to connect to a database server, e.g. Access, MySQL, Oracle, etc... but not open the .mdb file without that server running. So... you can use ODBC from Linux if the .mbd is on Windows, but for what you want you may just want to convert the .mdb to MySQL form. There should be an application on the MySQL links page to assist here. Best regards, Andrew Hill Director of Technology Evangelism OpenLink Software http://www.openlinksw.com Universal Data Access & Data Integration Technology Providers > -----Original Message----- > From: AJDIN BRANDIC [mailto:abrandic@coventry.ac.uk] > Sent: Tuesday, October 09, 2001 9:49 AM > To: php-general@lists.php.net > Subject: [PHP] access database on linux > > > Hi > > I have a few msaccess dbs (.mdb files) that I need to open, > extract and join > data then update a MySQL database. I want to open MsAccess files (.mdb) > using PHP, loop through results and create a .csv filethe just lod > content into a MySQL table. > > Say my file is called first.mdb > I am running RH6.2 and PHP4 > > How do I open a .mdb file? Do I need to use ODBC? > Any tutorials or example scripts. > > Regards > > Ajdin > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > > >