So, I am wondering why this (mdb) won't work for your porpoises. Here is another tutorial: http://bryanmills.net:8086/archives/2003/11/microsoft-access-database-using-linux-and-php/
Access is an ODBC style database, and unixODBC can connect to it. You need the mdb drivers. After that any tool that can connect to an ODBC source should work. Even OOo, I'd guess. Obviously PHP and Perl have libraries that interface with ODBC. Here is a list of tools that should work with ODBC stuff. http://www.linas.org/linux/db-api.html Check out SQSH : http://www.sqsh.org/ You might also consider Java. Here is a type 3 JDBC driver (all Java) for ms-access: http://www.aveconnect.com/jdbc-driver-MS-Access.htm You can probably find more. Also, be very aware of version differences. Older versions of Access files need to be upconverted to the latest version before they can be opened. I'd guess nerwer versions are not backward compatible. This may affect your usage vis-a-vie various driver support. What is the source for this? Can't you get them to export the records to CSV or MS Excell even? Ed On 11/26/06, Robert Citek <[EMAIL PROTECTED]> wrote: > Robert Citek wrote: > > I have a copy of an MS Access database on my Ubuntu 6.06 laptop and I'd > > like to query it. > > > > What tools have folks here used and would recommend? > > mdb-tools is one that was recommended on another list. Any others? > > Under Ubuntu 6.06: > > apt-get install mdbtools > > Here's a sample script to display the first few records from each table > in the database: > > db=foo.mdb > mdb-tables -1 $db | > while read table ; do > echo 'select * from '\"$table\" | > mdb-sql $db | > head > done | > less -iX -S -# 10 > > > Here's a sample script to export all the tables in the database as > tab-delimited files: > > db=foo.mdb > mdb-tables -1 $db | > while read table ; do > mdb-export -Q -d$'\t' $db "$table" \ > > db/"$table".csv > done > > > Regards, > - Robert > > > > _______________________________________________ > CWE-LUG mailing list > [email protected] > http://www.cwelug.org/ > http://www.cwelug.org/archives/ > http://www.cwelug.org/mailinglist/ > -- Ed Howland http://greenprogrammer.blogspot.com _______________________________________________ CWE-LUG mailing list [email protected] http://www.cwelug.org/ http://www.cwelug.org/archives/ http://www.cwelug.org/mailinglist/
