Yves, I am always open for cleaner method, but what I did was in MySQL created a table 'member' for data.
In Access exported as .txt make sure tab sequential. Back in MySql I made database active that had 'member' And did a: >mysql load data infile "c:\\mysql\\tmp.txt" into member; it actually went in quite cleanly. I am sure there are probably better ways, I am always willing to learn. But this is what worked for me today. Regards, Chuck -----Original Message----- From: Yves Arsenault [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:21 PM To: 1Mysql Subject: Access to MySQL Hello, Is there a small program that would transfer the contents of an Access database to MySQL? TIA, Yves Arsenault Carrefour Infotech 5,promenade Acadian Charlottetown, IPE C1C 1M2 [EMAIL PROTECTED] (902)368-1895 ext.242 ICQ #117650823 --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
