in reply to Re^9: Fetching data from Access using DBI
in thread Fetching data from Access using DBI

well, it looks like my problems are over, found this handy tool:

http://www.enobis.com/sw/mdb2mysql/

Did a dump of the database and it looks ok. it uses mdbtools.

H
  • Comment on Re^10: Fetching data from Access using DBI

Replies are listed 'Best First'.
Re^11: Fetching data from Access using DBI
by mje (Curate) on Aug 12, 2009 at 20:46 UTC

    I am glad you are happy with this solution. DBD::mysql is miles better than DBD::ODBC with mdbtools (due to mdbtools having a truly horrendous ODBC driver) but I suspect in time you will find you have just swapped a large set of problems for a slightly smaller set of problems. Best of luck, I suspect you'll need it.

[reply]

      Thanks but what I only needed was a dumb of the database, after that, it's mysql all the way. And it allowed me to waste energy experimenting with dbi and odbc.

      H
[reply]

In Section Seekers of Perl Wisdom