Kyle R. Burton on 20 Feb 2006 21:38:24 -0000


[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] perl module to read/write Access2002 tables


If you are on win32, you can connect to access databases via ODBC (though it is slow).  If you're not on Windows, there is the mdbtools project:

  http://mdbtools.sourceforge.net/

Though they only allow for reading.  I've used mdbtools and can say that it works for the most part.  When it doesn't a compact&repair of the mdb file often allows it to read the file effectivly.  The issue here is that there is no indication of the fact that the data is not quite right.

I have wrapped it with a simple XS module before (not a DBD module, just a one off).  I did this for an employer so I can't share the work, but it is easy to do.

Another option is to set up a windows box as a server, write a simple service on it that allows you to create new ODBC data sources (by copying a blank MDB file and then publishing them) via a simple remote API.

HTH,

Kyle


On 2/20/06, George Gallen <ggallen@slackinc.com> wrote:

I searched through CPAN and didn't see anything specific for Access2002.

I will need to open and read/write to a one of the .mdb tables then close.
  for a nightly update to some files that are manipulated by Access
  during the day.

The files are specifcally Access2002 files.

Thanks
George

George Gallen
Senior Programmer/Analyst
Accounting/Data Division
ggallen@slackinc.com
ph:856.848.1000 Ext 220

SLACK Incorporated - Delivering the best in health care information and education worldwide.
http://www.slackinc.com



___________________________________________________________________________
Philadelphia Linux Users Group         --         http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug





--
------------------------------------------------------------------------------
Wisdom and Compassion are inseparable.
        -- Christmas Humphreys
kyle.burton@gmail.com                            http://www.neverlight.com/~mortis
------------------------------------------------------------------------------
___________________________________________________________________________
Philadelphia Linux Users Group         --        http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion  --   http://lists.phillylinux.org/mailman/listinfo/plug