yes, if your server is windows based. Create a odbc system dsn to the access file on your server, then connect to that dsn. You can then pull data from it, connect to mysql and insert the data. If I remember correctly, you had wanted your users to upload the mdb file for you to extract the data. This may be tricky as I am not sure if you can bait and switch the file from under the odbc connections nose. Cheers Jason -----Original Message----- From: epeloke@echoman.com [mailto:epeloke@echoman.com] Sent: Thursday, December 12, 2002 10:33 AM To: PHP-DB Subject: copying data I asked a question sort of alone these lines the other day so please forgive me if it sounds familiar... If I have a microsoft access file .mdb on my server, can I use a php page to move the data from the file to a mysql db? 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
