I saved the email last time this was posted, didn't look into it but someone suggested looking at this site. http://www.intranet2internet.com . Another option was to link the table, not exactly sure of all the steps but maybe create an empty table in mysql with all fields and data types, then set up an odbc connection to mysql then link the empty table from access to mysql and copy data from access table to linked mysql table, this way its all done in access.
HTH, Steve Bradwell MIS Department. "If you give someone a program, you will frustrate them for a day. If you teach them how to program, you will frustrate them for a lifetime." -----Original Message----- From: Sandeep Murphy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 9:39 AM To: MySQL List Subject: access->mysql Hi, Can anyone please suggest a simple and effective method for converting a huge database i hv in Access xp to MySQL ?? hv tried various methods, including using dsns , a small script available at http://www.cynergi.net/exportsql/ etc.. they all work but not deliver a clean result... any tried and trusted method?? thnx in adv, sands --------------------------------------------------------------------- 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