I believe you could use DBD::ODBC to access the "Access"
database, and DBD::mysql to access the MySQL database, so
here's what I'd do:
* install the DBI module
* install the DBD::ODBC module
- then write a simple script to prove you can
connect to the "Access" database
* install the DBD::mysql module
- then write a simple script to prove you can
connect to the "MySQL" database
Once all that works, write a script that will have
two database handles - one to the "Access" database
and one to the "MySQL" database. The fetch loop
will read from the Access database and INSERT into
the MySQL database.
Once you install the modules listed above, read the
excellent included documentation by doing:
perldoc DBI
perldoc DBD::ODBC
perldoc DBD::mysql
HTH.
Hardy
John [EMAIL PROTECTED] wrote:
