Thank you very much! This is very helpful.
-sammy
--- Lawrence <lkrubner@g...> wrote:
> 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
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
> 
$subst('Email.Unsub').


__________________________________________________
Do You Yahoo!?
Try FREE Yahoo! Mail - the world's greatest free email!
http://mail.yahoo.com/