Re: UNIX MySQL to Microsoft Access

-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Am 24.07.00 um 15:01 hat bob Dobolina geschrieben: bD>I need to in someway convert a MySQL database on a FreeBSD Unix machine over to a Microsoft Access database. I'll also need to update the Access database with information from the MySQL version occasionaly. I've read a few archived messages that touched on this, but were unable to fully explain what would be involved. I understand that I'll probably need to convert the MySQL database over to ODBC first then somehow get that imported into Access. Any help or guidance would be greatly appreciated. Thanks in advance. All that stuff was in one line! Would you mind setting your line width to 72 chars? Thanks! Alright, now to your question. Just export the MySQL database to a CSV file. Then you tell Access to load that file, and convert it back to an Access DB. Done. - -- MfG, Jonas Jochum commandline net services - ------------------------------------------------------------------------- tel: 07223-911794 | cmd:~ # Systemadministration, Netzwerkverwaltung fax: 07223-911795 | cmd:~ # Einrichtung von *BSD/Linux-Servern d2 : 0173-5712481 | cmd:~ # Datenbank/Internetprogrammierung jj@commandline.de | cmd:~ # Webdesign www.commandline.de | -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.1 (FreeBSD) Comment: Made with pgp4pine 1.75 iEYEARECAAYFAjl8xpUACgkQF1ki3orczCBIJgCfbcW9VjtF45JfpO6y/jKUODzD kHYAn2rRjkE1Fmyv+Xdx+oMpxUgYlLb0 =XEHY -----END PGP SIGNATURE-----