I think the best way is to export Access 2000 tables to tab delimited text files and then use mysql LOAD DATA INFILE in mysql to get data from text files into MySQL tables. See manual for LOAD DATA INFILE syntax.
I'm not sure but maybe some utilities exist to convert Access to MySQL. Peter. > -----Original Message----- > From: Gary Portellas [mailto:[EMAIL PROTECTED]] > Sent: Tuesday, January 22, 2002 11:46 AM > To: [EMAIL PROTECTED] > Subject: Converting Access 2000 to Mysql > > > Hi All > > I am new to Mysql / Linux and would like to import my access > 2000 database > into a MYSQL database - is there an easy way to do this ?? > > Thanks > Gary > > > --------------------------------------------------------------------- > 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
