I'd go the ODBC route. If you have a server running Windows and the MyODBC driver, write a simple script (asp, cold fusion, php, etc) that allows users to do a file upload of the access db. Setup up a DSN to that file, and have the same script that handles the upload trigger the process of moving the data from the access DB to the MySQL db using ODBC.
One trick you'll need is that windows will lock the db whenever it's used, and leave it locked for however long the timeout is set on the DSN. So, you might want to add a bogus query that hits the access database and calls a column that doesn't exist, in order to break the DSN lock. HTH, Peter Janett New Media One Web Services ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ New Upgrades Are Now Live!!! Windows 2000 accounts - Cold Fusion 5.0 and Imail 7.1 Sun Solaris (UNIX) accounts - PHP 4.1.2, mod_perl/1.25, Stronghold/3.0 (Apache/1.3.22), MySQL 3.23.43 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ PostgreSQL coming soon! http://www.newmediaone.net [EMAIL PROTECTED] (303)828-9882 ----- Original Message ----- From: "Rick Emery" <[EMAIL PROTECTED]> To: "Edward Peloke" <[EMAIL PROTECTED]>; "PHP general list" <[EMAIL PROTECTED]> Sent: Tuesday, January 14, 2003 7:32 AM Subject: Re: [PHP] data move, Please Help.. > try GOOGLE: access mysql php conversion > > I did > ----- Original Message ----- > From: "Edward Peloke" <[EMAIL PROTECTED]> > To: "PHP general list" <[EMAIL PROTECTED]> > Sent: Tuesday, January 14, 2003 8:48 AM > Subject: [PHP] data move, Please Help.. > > > Ok, I know I have asked this question before and I have asked it on the db > forum, on asp forums, java applet forums, searched google, etc but can't > really seem to find anything. I have to come up with a way to move data > from an access db to the mysql db on the webserver. If I have to, I can > upload the access file to the server and then transfer the data. Are there > tutorials or samples somewhere of how to do this in php? > > Best case scenario would be to come up with a way (using any tool, java, > activex, etc) to connect to the users machine and then upload the data > directly from there. > > ANY help would be greatly appreciated! > > THANKS, > Eddie > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, visit: http://www.php.net/unsub.php > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
