Beefy Boxes and Bandwidth Generously Provided by pair Networks
good chemistry is complicated,
and a little bit messy -LW

Retrieve value from .mdf database file

by vivid (Beadle)
on Nov 30, 2012 at 10:40 UTC ( #1006452=perlquestion: print w/replies, xml ) Need Help??
vivid has asked for the wisdom of the Perl Monks concerning the following question:

Dear Monks,

How can i retrieve data from .mdf database file. Please help me.



Replies are listed 'Best First'.
Re: Retrieve value from .mdf database file
by Sinistral (Prior) on Nov 30, 2012 at 19:37 UTC

    A file with the extension mdf is a binary file format produced by Microsoft Access. There are several ways in the Perl world to programatically open, read, and manipulate such a file:

    • If you are on a Windows machine with Microsoft Access installed, you can use Win32::OLE to open Access and get data from the file. There is some information in Ms Access and win32 ole, but it seems that unlike Excel, there is not as much information on manipulating Access using OLE via Perl.
    • You can, again on Windows, create an ODBC DSN that can be used in conjunction with DBI and DBD::ODBC to treat Access as just another database server.
    • You can, instead of ODBC, read using an ADO connection to Access. This, again, is a Microsoft Windows solution.
    • If you're not on Windows (hopefully using a nice Perl stack like Strawberry Perl or ActiveState's Perl), then you might be able to get away with using MDB Tools and convert your mdb file into some other format.
Re: Retrieve value from .mdf database file
by space_monk (Chaplain) on Nov 30, 2012 at 13:49 UTC
    Connect SQL Server up to it and then use the Perl DBI libraries to hook up to the resulting database.
    A Monk aims to give answers to those who have none, and to learn from those who know more.
Re: Retrieve value from .mdf database file
by Anonymous Monk on Nov 30, 2012 at 11:17 UTC
    did you check cpan? do you have db docs?

Log In?

What's my password?
Create A New User
Node Status?
node history
Node Type: perlquestion [id://1006452]
[davido]: I find it annoying when I see "People tend to average between X and Y.", that's not an average, that's a range.
[Corion]: Ask about the median ;)
[jdporter]: posts like this one make me realize, ruefully, just how much my mind has deteriorated in recent years/months.
[jdporter]: "When all your nails look like trolls, all your hammers look like trolls."

How do I use this? | Other CB clients
Other Users?
Others about the Monastery: (9)
As of 2018-06-21 16:21 GMT
Find Nodes?
    Voting Booth?
    Should cpanminus be part of the standard Perl release?

    Results (118 votes). Check out past polls.