[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