From: "csvega" <csvega@y...>
> Right now assume I can input data directly to access
> only, I want to find an example that:
> the computer itself can periodically check
> the status if there is any new data added on access,
> and if it does, they will obtain the new data
> information, and automatically transfer them to MySQl.
> so everthing is automatic

As you probably know, there are many programs out there for converting Access info to MySQL. As for
automatic checks for new, you could set a cron job to run a simple PHP script that checks to see if
anything new is in the Access database. If it's new, then the PHP calls the convert program. Don't
forget, on Unix, PHP can be used exactly like a shell language, just like bash or korn.



http://www.ispirer.com/fromsupp/access_to_mysql.html
Yes, you can use Chyfo to convert an Access database into MySQL. It can export Access data to text
files, generates DDL scripts for MySQL (CREATE TABLE, CREATE INDEX and primary keys).
Chyfo generates command scripts for loading data using the MySQL LOAD DATA INFILE command.
It's easy to use. For example, the command chyfopro.exe /d=mdb /t=% /target=mysql will export all
tables from an Access database. Then you have to run generated scripts to move tables into MySQL.


http://www.convert-in.com/acc2sql.htm
Access-to-MySQL is a program to move MS Access databases to MySQL server. Depending on your
privileges on the target MySQL server, you can either export MS Access data into new database, or
overwrite the contents of an existing MySQL database.
Features
All MS Access data types and attributes are supported
Works with all versions of Unix and Windows MySQL servers
Converts indexes with all necessary attributes
VServer user's option (see below)
Converts password protected MS Access databases
Exports MS Access databases into a dump file (see below)
Easy-to-use wizard-style interface
Full install/uninstall support