-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Steve,
It is quite possible. You can use MyODBC to connect your current Access database(s) into your MySQL server directly, the major drawback is that you'd have to create the overall table structure in MySQL first and then link the table from MySQL into Access through the File|External Data|Link Table... Menu. Or you can find and download DBTools which will export your tables for you into MySQL. I use MyODBC to connect some of my users to MySQL through Access, as that was the easiest route for my end-users. HTH, Bryant H. Hester - -----Original Message----- From: Steve Jackson [mailto:[EMAIL PROTECTED]] Sent: Tuesday, November 26, 2002 8:38 AM To: MySQL General Mailing list Subject: Is it possible to export data from access to MySQL? Is it possible to export data from MS Access into MySQL? If so how? I have a huge amount of data that will take weeks to input and I've convinced my boss to use MySQL rather than any other DB because of it's compatibility with PHP. However I (probably hastily) *assumed* that there would be a way to export the data. Any ideas? Steve Jackson Web Developer Viola Systems Ltd. http://www.violasystems.com [EMAIL PROTECTED] Mobile +358 50 343 5159 -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 7.0.3 for non-commercial use <http://www.pgp.com> iQA/AwUBPeOJiklWu7/HFp4nEQLL8gCdGyKJWMwrVjqnyUczHBQswrt2xIYAoMJH H2FttK0BuepoUPFNby40uuGP =Yty5 -----END PGP SIGNATURE----- --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
