[CentOS] Using an MS Access database from CentOS release 5.7 (Final)
Luigi Rosa
lists at luigirosa.com
Thu Dec 15 04:45:38 UTC 2011
-----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-----
More information about the CentOS
mailing list