-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Ron Young said the following on 14/12/11 22:21:
@Work requires me to manipulate the MS Access database (mdb) file located on an XP box that is an integral part of a third party application that is central to the business.
Does anyone have experience doing so?
I had to import some customer's data from an Access application for a new (PHP) version of that application I wrote.
I used mdbtools http://mdbtools.sourceforge.net/
I scripted the conversion this way:
mdb-export -I -S -X -DF accessfile.mdb "accesstablename" | sed 's/accesstablename/sqltablename/g' | sed 's/$/;/g' > /tmp/aaa cat header.sql /tmp/aaa > import.sql mysql --user=user --password=password < import.sql
header.sql file contains just this line:
use database;
Ciao, luigi
- -- / +--[Luigi Rosa]-- \
It is not the strongest of the species that survives, nor the most intelligent, but the one most responsive to change. --Charles Darwin