How do I transfer information from a MySQL DB to an Access DB?

[mosiondz]

I am attempting write a function to transfer information from a mySQL database on a Unix-based system to an Access database on an NT-based system. What is the best way to go about this problem?

I had thought about having an ActiveState Perl script on the NT server receive information from an HTTP call from the Unix system, and then put that information into the database, but I was wondering if there was a better way to go about this, perhaps by connecting directly to the Access database in some way.

Originally posted as a Categorized Question.

[antjock]

Just install the MyODBC driver on your winders machine.

It's pretty easy to install and get up and running. I have set this up in the past for clients who have mysql databases on a webserver, but want to see and manipulate the data on their winduhs machine in Access.

hope that helps,
ant

[btrott]

Try using DBI. You could use DBD::MySQL to connect to the MySQL db, then use DBD::ODBC (I think) to connect to the Access db. Then you can select from one database handle and insert into the other.

[Anonymous Monk]

Take a look at DBIx::Copy. You pass it two database handles and tell it which tables you want to copy. It doesn't have facilities for recreating table structure, though, so you'll need to use DB-specific commands (either from command-line tools or DBI) to create the tables first.

[vaevictus]

Or, don't use perl, and just open up access with an ODBC driver and access the data directly from access....