[Gllug] Reading an Access97 mdb file

[Stan]

> On Tue, 7 Jan 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.
> 
> What platform are you running on?  You could do all kinds of funky things
> from within Perl if you've got access to a running copy of Access.  There
> was a Perl Journal on this called "Using DBI with Microsoft Access" which
> O'Reilly have just republished as part of "Computer Science & Perl
> Programming" (http://www.oreilly.com/catalog/tpj1/) Though I haven't got
> my copy with me at work and I haven't had a chance to read that article
> yet.
> 
> > 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!
> 
> You could script this exporting with Perl, getting it to start Access and
> controling it remotely.

The card system is running on WinXP Pro.  This sounds like a more
powerful method, there are a few other things that I'd eventually like
to be able to do with this damn access database and this might be the
way to go, and would save me fiddling with VB (which is what I thought
I'd have to do).

I'll pop into a bookshop at lunchtime and see how tricky it all looks
(I've never tried controlling windows aps through scripting - I wasn't
sure that it was even possible)


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