Quoting cowboy <[EMAIL PROTECTED]>: > Hello all, > > I have a mdb file(ms access) on linux server. > Is there any method to access this mdb file from perl? >
Here's a good summation post and follow-up on London Perl Mongers list: http://kochi.etla.org/london.pm/html/2002/07/msg00068.html Basically, it recommends two tools -- MDBTools on Linux and http://mdbtools.sourceforge.net/ ActivePerl's DBD::ODBC on Windows (I assume). I had the (misfortunate) task of dealing with an MDB on Linux just over a year ago and found MDBTools to be very sufficient for extracting data from the MDB (it didn't write to the file at the time). Take a look at that SourceForge tool. If you want to read/write to the file, you might be better off making a secure connection between an MS Access DB on a windows machine to connect with your Linux-based database server. I use this technique on occasion by creating an SSH tunnel via PuTTY on Windows to make available the Linux server MySQL database to the Access program on my desktop. Then I connect to MySQL via ODBC to load local data (for customer data dumps, etc) and disconnect after completion. HTH, Robert J Taylor -- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
