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:[EMAIL PROTECTED]] Sent: 22 November 2002 14:30 To: Edward Peloke; [EMAIL PROTECTED] Subject: Re: [PHP-DB] 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
