Did anything come of this? Has anyone tried using DBD::ODBC with the mdbtools ODBC driver to access an Access .mdb file[*](possibly networked via Samba etc etc)?
Tim. [*] Of course it's really a 'Jet' database engine file, and Jet is also used in MS Money, Project, IIS, and Exchange etc. On Wed, Jun 26, 2002 at 01:05:44AM +0100, Tim Bunce wrote: > I was simply expressing a preference that if there was to be > "AnyData::Format::Access.pm using mdbtools" > then I'd rather there was > "DBD::Access using mdbtools" > > Since I've not looked at mdbtools I can't really comment much more than that. > > I saw Brian Bruns (the developer) mention that mdbtools includes a > (buggy) ODBC driver. So long as it's functional enough now to do > simple selects then that's probably the best way to go - using > DBD::ODBC. > > Tim. > > On Tue, Jun 25, 2002 at 04:11:09PM -0700, Tim Harsch wrote: > > Forgive my naivity (or just flawed understanding) but how would one go > > about creating a DBD::Access? For instance DBD::Oracle is built on OCI, > > does Access have a similar network protocol? I thought that ODBC was > > about the only MS supported method of communicating to it... > > > > > -----Original Message----- > > > From: Tim Bunce [mailto:[EMAIL PROTECTED] > > > Sent: Tuesday, June 25, 2002 2:18 PM > > > To: Jeff Zucker > > > Cc: Orlando Andico; DBI-Users; dbi-dev; [EMAIL PROTECTED] > > > Subject: Re: MS Access > > > > > > > > > On Tue, Jun 25, 2002 at 10:27:20AM -0700, Jeff Zucker wrote: > > > > Orlando Andico wrote: > > > > > > > > > It IS possible to read MSAccess files on a Linux box. > > > > > http://mdbtools.sourceforge.net/ > > > > > > > > > > > > Hmm, I had no idea that was available, forget my advice > > > about saving the > > > > Access files as CSV. > > > > > > > > At first glance it looks like it would be trivial to build an > > > > AnyData::Format::Access.pm using mdbtools which would then provide > > > > direct DBI interface to the MDB files. If anyone is > > > interested in doing > > > > this, let me know and I'll help. > > > > > > I'd rather someone did a DBD::Access. > > > > > > Tim. > > > > >
