Stack Overflow
Stack Overflow

Questions tagged [mdbtools]

Read Microsoft's Access databases on *nix

57 questions
11
votes
1 answer

Access data base import to R-installation of mdb tools on Mac

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_vegBY1.mdb') #(data under…
user3514704
  • 141
  • 1
  • 5
10
votes
4 answers

DSN-less connection with PHP ODBC using MDBTools Driver

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 contents of /etc/odbc.ini: [logindb] Description = Microsoft…
Tim S
  • 5,023
  • 1
  • 34
  • 34
8
votes
4 answers

mdb-export not creating CSV file

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 dump its intended function? If the latter is the case,…
makewavesnotwar
  • 975
  • 3
  • 8
  • 13
8
votes
4 answers

Is there a replacement for mdbtools?

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. Features I need: SQL, either with python bindings…
Georg Schölly
  • 124,188
  • 49
  • 220
  • 267
6
votes
3 answers

WHERE clause not working in SQL-query using mdbtools

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 installed mdb-tools and configured unixODBC to use it.…
khartvin
  • 551
  • 1
  • 7
  • 20
3
votes
0 answers

Read MS Access JET 4 database (.mdb) using python and unixODBC on Ubuntu 11.10: getting bad values

I'm having some problems trying to read a Microsoft Access database (JET 4 .mdb) using Python 2.7.2 (unixODBC 2.2.14, pyodbc 2.1.11 and the mdbtools driver) on Ubuntu 11.10 32-bit. Yes, I know it is horrible idea, but oddly enough it is the easiest…
rhkarls
  • 196
  • 3
  • 13
3
votes
0 answers

Mono + MDBTools: Encoding Issue

I'm working on a C# application that has to read an Access database (.mdb), on Linux. I'm using Mono to compile and run the application. Suppose I have a test database that I create in Access 2013. It has one table: TestTable, with the default ID…
millinon
  • 1,528
  • 1
  • 20
  • 31
3
votes
1 answer

Python error: missing 'mdb-schema' when using python_access package

Running on Ubuntu 16.04, Python 3.6.2 I have successfully used this package before. In fact, it works on a different pc but not the one I need it to work on. https://pypi.python.org/pypi/pandas_access import pandas_access as mdb df =…
BaconSandwich
  • 165
  • 2
  • 13
3
votes
3 answers

Extract and sort data from .mdb file using mdbtools in Python

I'm quite new to Python, so any help will be appreciated. I am trying to extract and sort data from 2000 .mdb files using mdbtools on Linux. So far I was able to just take the .mdb file and dump all the tables into .csv. It creates huge mess since…
Pasha
  • 169
  • 1
  • 1
  • 11
2
votes
0 answers

How can use ORDER BY in PDO query with PHP? And oversize memory if it find NULL field

I have this PHP code, running on Ubuntu server 22.04: $query = "SELECT * FROM info ORDER BY data DESC LIMIT 20"; $mdb_file = 'database.mdb'; $uname = explode(" ",php_uname()); $os = $uname[0]; switch ($os){ case 'Windows': $driver =…
andreaS
  • 21
  • 4
2
votes
0 answers

odbc_connect problem with mdbtools and unixodbc

I would like to acccess a mdb file in a windows machine (windows server 2003) from a linux machine (centos 6.10) Im using mdbtools and unixodbc so far what i did odbc.ini [mydatabase] Driver = MDBTools Description = Microsoft Access Try…
darrenx
  • 33
  • 5
2
votes
0 answers

MDBTools driver not working properly on MS Acess memo data types

I'm trying to read formatted MS Access databases after uploading them on server to store the data in it into MySQL server. The database contains memo data type which by using unixODBC with MDBTools and PDO was not readable. I have PHP 7.2.17-1…
Azam Nasir
  • 21
  • 3
2
votes
5 answers

Import MDB file into Python (pandas) on Mac

I'm running python 3.6 on a mac. I have downloaded an mdb file but do not have Microsoft access, I'd like to import each table into python and work with it there. I have installed mdbtools and run the following from Spyder: import pandas as…
mks212
  • 901
  • 1
  • 18
  • 40
2
votes
1 answer

converting .mdb file into numpy or hdf5

Is there any API in python that can load .mdb file in linux environment and convert them into python friendly data structure like numpy or hdf5?
thetna
  • 6,903
  • 26
  • 79
  • 113
2
votes
2 answers

Can't open cursor lib 'libodbccr'

I'm trying to connect to a .mdb file, and installed MDBTools When I run the PHP script this is the error I get; [unixODBC][Driver Manager]Can't open cursor lib 'libodbccr' Under /usr/lib64 I find the following similar…
lshas
  • 1,691
  • 1
  • 19
  • 39
1
2 3 4