I'm attempting to read from an Access database using MDBTools drivers to execute an odbc_connect on Ubuntu 11.10. It's working fine when using the DSN setup in /etc/odbc.ini. Below are the content...

When I run mdb-export, the program dumps the comma delimited table to the terminal, but does not create a csv file as far as I can tell. Is mdb-export creating a csv file somewhere or is this dum...

I've been working on a project using the LAMP server that requires frequent read of the MS-ACCESS database, stored in *.mdb file. The database has one table and about 40.000 rows in it. I've insta...

The plan ist to import an Access database into R to filter out what I need to make statistical analysis. A colleague suggested me the following code: library(Hmisc) d <- mdb.get('140410_db_veg...

Can anyone tell me if there is limited SQL support using unixODBC drivers on Ubuntu with PHP? I've setup a basic lamp server on Ubuntu 11.10, and I'm trying to query an Access database. I've instal...

I'm using mdbtools' SQL functionality to connect to an .mdb file on linux. Mdbtools is still beta and hasn't been updated since 2007, many features like sufficient SQL support aren't available yet....