mdbtools (or alternatives) for getting Access97 data into mysql
 

Morning,

I was hoping to use mdbtools to extract data from some Access databases overnight. I have yum installed the tools (on CentOS 5) and also downloaded and (eventually!) compiled the latest release from the mdbtools web site, but I either get 'buffer overflow' errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but sourceforge's cvs login keeps timing out!

I have had a good Google and searched these forums and picked up some notes but no concrete advice so is anyone hereabouts using mdbtools successfully, or can anyone suggest any other tools that will dump access databases on a scheduled basis? I have done test migrations using the MySQL gui tools and that works fine, but I don't think the operation can be scripted.

On a side note, I also need to do the same for MS-SQL data - does anyone have any favourite tools for automating data extraction? Everything ultimately needs to end up in a MySQL database.

Thanks

EDIT: Managed to Checkout the CVS version at last!!! This has compiled OK but most of the mdb tools commands return no output. Any good sugegstions for debugging?

Personally I'd use Perl, using the generic front-end module DBI (http://search.cpan.org/~timb/DBI-1.605/DBI.pm see the diagram there), and the relevant backend modules eg http://search.cpan.org/~capttofu/DBD...b/DBD/mysql.pm.
See tutorials here: http://www.perlmonks.org/?node=Tutor...se-Programming, also 2nd example in post #2 here http://www.dbforums.com/showthread.php?t=1061119