You can actually do this from any machine, although you will need an ODBC driver on the Linux/Mac OS X/Unix side.
Another alternative is to dump the .mdb to mysql format and move it over.
But ODBC is the way to go. Beginning PHP Databases from Wrox cover this a lot, but you can get started with just a DSN and a basic odbc_connect.
Create it as a System DSN - it will cause less problems.
If you are on a *nix or Mac OS X, then you will want to tell the PHP script where the files are that contain the DSN (odbc.ini) and the ODBC Driver Manager (libiodbc.so). There are basic examples and explanations in the HOWTO at www.iodbc.org. It's *nix geared, but just remove the putenv()'s at the beninning of the examples and they will work fine.
Best regards,
Andrew Hill
Director of Technology Evangelism
OpenLink Software http://www.openlinksw.com
Virtuoso Universal Server http://www.openlinksw.com/virtuoso/
At 02:27 PM 12/19/2002, SELPH,JASON (HP-Richardson,ex1) wrote:
If you are on a windows machine, you can create a DSN to the access file and use odbc from php to connect to it. -----Original Message----- From: epeloke@echoman.com [mailto:epeloke@echoman.com] Sent: Thursday, December 19, 2002 12:59 PM To: php-db@lists.php.net Subject: extracting data I posted this to the php general list also so forgive me if you are seeing this twice. Can I use php to extract data from an access db? The php script and access db will be local. I will then upload the file to my server. Thanks, Eddie -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
