-----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 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk7pe24ACgkQ3kWu7Tfl6ZRCswCgxwgjhEYh8mzVwpXMxjS2g3QF 8yUAoI1BDogfHFCfrMPNzzK+Pe/faQxC =rC14 -----END PGP SIGNATURE-----