Read Microsoft's Access databases on *nix
Questions tagged [mdbtools]
57 questions
0
votes
0 answers
No such file or directory when exporting files using bash script
I am working on a bash script which iterates over mdb files and exports them to a csv.
Here is my code:
#!/bin/bash
YEAR="2001/"
INFOLDER="/local/data/datasets/Convergence/"
OUTFOLDER="~/Workspaces/Ventilator_Repository/dataset/csv/"
for f in…
Matin Kh
- 5,192
- 6
- 53
- 77
0
votes
1 answer
mdb-export changes the GUID for every row
I'm using mdb-tools on FreeBSD to convert a Microsoft Access DB to MySQL.
The script looks like this (to_mysql.sh):
#!/usr/local/bin/bash
echo "DROP TABLE IF EXISTS Student;"
mdb-schema -T Student $1 mysql
mdb-export -D '%Y-%m-%d %H:%M:%S' -I…
Victor
- 1
- 2
0
votes
2 answers
MDBTools driver not returning string values with PHP MS-Access
We have an MS Access attendance database, which is updated by biometric hardware. So there is no way to replace MS Access. Now we need to provide the attendance information on our intranet web, for which we are trying to periodically read the…
kpk
- 13
- 5
0
votes
1 answer
bash script to update MySQL from Access using MDB Tools
I'm trying to make a cronjob script that will take entries in a MS Access database (*.mdb) and update the sql database on the server. The script I found drops the tables and replaces them with the ones in the mdb file.
#!/bin/bash …
PurpleAnarchist
- 30
- 8
0
votes
1 answer
DISTINCT clause doesn't work with odbc_exec on linux
I'm trying to read rows from a .mdb file (MS Access) on Linux (Ubuntu), I've installed php5-odbc, mootools etc... My code is:
$dbName = "/path/file.mdb";
$handle=odbc_connect ("DRIVER=MDBTools; DBQ=$dbName;", "", "");
if(!$handle) {
print…
Giuseppe Romano
- 14
- 1
- 6
0
votes
0 answers
Select number between 0 and 1 MDB
I am using mdbtools to connect to a mdb-file and retrieve some data from a table in the mdbfile.
In the table there is a field which contains values like
0.17, 0.25, 0.17, 0.50, 0.75
I see these numbers when looking at the db with MDB Explorer on…
lshas
- 1,691
- 1
- 19
- 39
0
votes
1 answer
mdb-tools mySQL syntax error
I have a .mdb file I'm trying to export into a mySQL database.
Using mdb-schema Data.mdb | mysql -u root -p Database
I get the following error:
ERROR 1064 (42000) at line 11: You have an error in your SQL syntax; check the manual that corresponds to…
Tomasz Kaminski
- 900
- 7
- 14
0
votes
2 answers
Migrating MS Access data to MySQL: character encoding issues
We have an MS Access .mdb file produced, I think, by an Access 2000 database. I am trying to export a table to SQL with mdbtools, using this command:
mdb-export -S -X \\ -I orig.mdb Reviewer > Reviewer.sql
That produces the file I expect, except…
hoosteeno
- 644
- 5
- 17
0
votes
1 answer
mdb tools sql query table name space separated
I'm trying to make an ODBC query for my .mdb database. I'm using mdbtools driver. The code is written in C using Eclipse. The only problem is that when I write for example:
"SELECT 'last week' FROM MyTable GROUP"
it doesn't work cause it cannot…
user1715161
- 1
- 2
0
votes
2 answers
Using custom shell scripts on Heroku
I'm using Heroku and git to power a django app. Part of the functionality of the site allows users to upload .mdbs (Microsoft Access Databases) , which we then parse using a shell script that calls mdbtools (http://mdbtools.sourceforge.net/). The…
mythander889
- 915
- 5
- 16
- 23
0
votes
1 answer
Django requirements.txt pip for mdbtools
I'm trying to use mdbtools in a django app I have. I've included the following two lines in my requirements.txt file:
mdbtools-dev
mdbtools
but am running into some errors:
....
Requirement already satisfied (use --upgrade to upgrade): stripe in…
mythander889
- 915
- 5
- 16
- 23
-2
votes
1 answer
How to Read .mdb file using python 64 bit?
i am getting filenot found error in pandasaccess
MDB tools are also not working
mdb-tables : The term 'mdb-tables' is not recognized as the name of a cmdlet, function, script file, or operable
program. Check the spelling of the name, or if a path…
Vignesh
- 1,553
- 1
- 10
- 25