Re: data move, Please Help..

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 webmaster@newmediaone.net (303)828-9882 ----- Original Message ----- From: "Rick Emery" <remery@emeryloftus.com> To: "Edward Peloke" <epeloke@echoman.com>; "PHP general list" <php-general@lists.php.net> 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" <epeloke@echoman.com> > To: "PHP general list" <php-general@lists.php.net> > 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 >