[CentOS] Using an MS Access database from CentOS release 5.7 (Final)

Thu Dec 15 04:45:38 UTC 2011
Luigi Rosa <lists at luigirosa.com>

-----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-----