in reply to Read static .MDB files?

There certainly is an answer to this oft repeated question.

See that little box next to the word search at the top of the page? Try typing 'access' in there and have a look at the results.

(Methinks I assumed to much...)

Update:It appears I was a little hasty. Without opening the file, you might just need OLE::Storage to read the raw OLE storage streams, but it would be complicated. It would certainly make you question whether it was worth it.

Have a think about what runrig has suggested.

*~-}hotyopa{-~*

Replies are listed 'Best First'.
Re: Have you had a look yet?
by runrig (Abbot) on Feb 06, 2001 at 03:16 UTC
    We've determined through the CB that he wants to access the data from gzipped files on Unix. DBI won't help, you'd need something like Parse::Access which doesn't AFAIK exist yet.

    Any reason why you can't get the files to a PC with Access on it, then use DBI/DBD::ODBC or Win32::ODBC? Or export the data to a delimited or other format? Maybe even write a script to unzip the files and Net::FTP them to a Windoze box with Access on it? Automate any necessary commands on the Windoze box with Net::Telnet or maybe Expect (I've never used Net::Telnet, but it looks like if you use it you don't need Expect...)?

[reply]
      As I recall you don't actually need access installed to use *.mdb files. I _think_ I recall someone saying they had used DBD::ODBC to read those files under a unix system. However you may (or may not, try it) need an ODBC driver, but there is supposedly (according to the docs), a ODBC driver included with the DBD::ODBC source. Otherwise there are links to other cross-platform ODBC drivers in those docs.
[reply]
Re: Have you had a look yet?
by arturo (Vicar) on Feb 06, 2001 at 03:13 UTC

    Notice how he says he wants to be able to do this *without running Access*. He wants to parse the database file directly.

    Philosophy can be made out of anything. Or less -- Jerry A. Fodor

[reply]

In Section Seekers of Perl Wisdom