On Nov 27, 2006, at 15:43 , Robert Citek wrote: > Ed Howland wrote: >> What is the source for this? > > This is one of the database that ByteWorks uses. But I can think > of at > least a dozen other use cases. > >> Can't you get them to export the records to CSV or MS Excell even? > > I could. Right now I'm exploring the solution space. Since I already > know how to export as CSV or Excel, I thought I'd move to the next > level: reading the .mdb file directly. > > Ideally, I'd like to read from and write to the .mdb file from within > Ubuntu using only OpenSource software, i.e. sans Access. That way > I can > grab a copy of the database, make changes to my copy, and then copy my > version over the original. But if I can only extract data, that's OK > for now.
Since you must run Windows anyway, the best means to access Access is through DBD::ODBC (Perl). This will require some setup on the Windows box. Oh yeah- don't use Access concurrently. Cheers, M _______________________________________________ CWE-LUG mailing list [email protected] http://www.cwelug.org/ http://www.cwelug.org/archives/ http://www.cwelug.org/mailinglist/
