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/
