Art Alexion on 21 Feb 2006 14:15:22 -0000 |
Does OpenOffice.2 handle them? George Gallen wrote: > 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 > > -----Original Message----- > *From:* plug-bounces@lists.phillylinux.org > [mailto:plug-bounces@lists.phillylinux.org]*On Behalf Of *Kyle R. > Burton > *Sent:* Monday, February 20, 2006 4:38 PM > *To:* Philadelphia Linux User's Group Discussion List > *Subject:* 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/ <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 > <mailto: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 > > -- _______________________________________ Art Alexion Arthur S. Alexion LLC PGP fingerprint: 52A4 B10C AA73 096F A661 92D2 3B65 8EAC ACC5 BA7A The attachment -- signature.asc -- is my electronic signature; no need for alarm. Info @ http://mysite.verizon.net/art.alexion/encryption/signature.asc.what.html Key for signed PDFs available at http://mysite.verizon.net/art.alexion/encryption/ArthurSAlexion.p7c The validation string is TTJY-ZILJ-BJJG. ________________________________________ Attachment:
signature.asc ___________________________________________________________________________ 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
|
|