A little more detail Install MyODBC - you will need it on all machines In Access File -> Get external data -> Link tables ->ODBC data sources -> MyODBC data source You now have a direct link from Access to MySql and can run an Access query to load the data straight into MySql. I did this a while ago and can't remember more detail, but I hope this will point you in the right direction. Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 ----------------------------------------------- -----Original Message----- From: 1LT John W. Holmes [mailto:holmes072000@charter.net] Sent: 22 November 2002 14:30 To: Edward Peloke; php-db@lists.php.net Subject: Re: autoupload > I am currently creating a php/mysql site for a client. Many of the > customers who will be using this site also use a vb/access program to store > a lot of the same data. The client asked me last night if we could write an > app that would run on the customers machine that would routinely take data > from the access db on their machine and automatically upload it to our mysql > site. Any ideas on how this can be accomplished? You'd have to write a little vB or C program to do it, unless you're going to install PHP on every computer. ---John Holmes... -- 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
