Beefy Boxes and Bandwidth Generously Provided by pair Networks
There's more than one way to do things
 
PerlMonks  

Re: Have you had a look yet?

by runrig (Abbot)
on Feb 06, 2001 at 03:16 UTC ( [id://56550]=note: print w/replies, xml ) Need Help??


in reply to Have you had a look yet?
in thread Read static .MDB files?

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...)?

Replies are listed 'Best First'.
Re: Re: Have you had a look yet?
by repson (Chaplain) on Feb 06, 2001 at 13:00 UTC
    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.

Log In?
Username:
Password:

What's my password?
Create A New User
Domain Nodelet?
Node Status?
node history
Node Type: note [id://56550]
help
Chatterbox?
and the web crawler heard nothing...

How do I use this?Last hourOther CB clients
Other Users?
Others drinking their drinks and smoking their pipes about the Monastery: (6)
As of 2024-04-18 19:54 GMT
Sections?
Information?
Find Nodes?
Leftovers?
    Voting Booth?

    No recent polls found