[Gllug] Reading an Access97 mdb file

Jonathan Dye jonathan.dye at automationpartnership.com
Tue Jan 7 13:04:17 UTC 2003


Stan wrote:
> Does anyone know of a way that I can extract data from a table held in
> a access97 .mdb file...a perl modules would be best (can't find
> anything on CPAN) but any linuxy thing would be useful.
> 
> I know that I can export the data if I run access on a windows machine
> but this is a task that would need to be done daily so a nightly cron
> seems best to me! 
> 
> Oh and I'm stuck with access97 on the windows machine (unless someone
> here did find a swipe card door-lock system which runs on a sensible
> platform)

Could you replace the database with one that just included views that point
to a unix based database?  I believe that you can access external databases
from within Access and I'm pretty sure you can access something like
Postgress.

JD

_____________________________________________________________________
This message has been checked for all known viruses by the 
MessageLabs Virus Scanning Service

-- 
Gllug mailing list  -  Gllug at linux.co.uk
http://list.ftech.net/mailman/listinfo/gllug




More information about the GLLUG mailing list