Beefy Boxes and Bandwidth Generously Provided by pair Networks
Your skill will accomplish
what the force of many cannot
 
PerlMonks  

Re: parse MS Access DB (.MDB)

by mje (Curate)
on Oct 14, 2014 at 12:02 UTC ( #1103724=note: print w/replies, xml ) Need Help??


in reply to parse MS Access DB (.MDB)

As already mentioned mdbtools is pretty much your only option if you won't/can't install an ODBC driver or if you need to do this for free. However, having attempted to use mdbtools I gave up and use an ODBC driver under DBI and DBD::ODBC now as there was too much broken or not implemented in mdbtools - YMMV. If you are using the new MS Access files (.accdb) it is even worse (see mdbtools bugs and files last changed 8 years ago). MS Access ODBC drivers for Linux are available but they tend to be commercial.

Replies are listed 'Best First'.
Re^2: parse MS Access DB (.MDB)
by bangers (Pilgrim) on Oct 15, 2014 at 15:10 UTC
    Having reviewed mdbtools and looked at ODBC drivers we have decided to go back to the client and insist they provide the data in a more sensible format. Thank you to everyone who helped.

      Hello bangers,

      If, for whatever reason, you find yourself needing to fall back to a Plan B, it occurs to me that you could read Access files on Linux by installing either Apache OpenOffice or LibreOffice. Both are free and open source, and should be able to read .mdb files. Just a thought, in case you need another option.

      Hope that helps,

      Athanasius <°(((><contra mundum Iustus alius egestas vitae, eros Piratica,

Log In?
Username:
Password:

What's my password?
Create A New User
Node Status?
node history
Node Type: note [id://1103724]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this? | Other CB clients
Other Users?
Others musing on the Monastery: (4)
As of 2019-04-19 20:23 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?
    I am most likely to install a new module from CPAN if:
















    Results (107 votes). Check out past polls.

    Notices?
    • (Sep 10, 2018 at 22:53 UTC) Welcome new users!