|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
|
RE: [PLUG] perl module to read/write Access2002 tables
|
Can
you connect to an Access2002 database using ODBC if you don't have Access on
that machine?
I have
files that are created by a third party software that creates "Access2002
database tables". I only
have
Access2000 which will not read these tables.
I
don't care how slow it is, it will be in the middle of the night on an automated
process.
Thanks
George
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
___________________________________________________________________________
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
|
|