phpMyAdmin has an 'export to csv or Excel' function. If you are running php this will produce a CSV file you can import directly into Excel
http://www.phpwizard.net/projects/phpMyAdmin/ hth Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia Birmingham UK www.sunmaia.net tel. 0121-242-1473 International +44-121-242-1473 ----------------------------------------------- -----Original Message----- From: Lamar [mailto:lamarts@;flash.net] Sent: 12 November 2002 02:15 To: [EMAIL PROTECTED] Subject: Table solution Hello All, I want to copy a table from a webserver that has MySQL database server located on it, then, ftp to my local machine to insert into my local database. any ideas on how to do this? my goal is to create an Excel spreadsheet from the table for distribution. I have created the spreadsheet using the database on my local machine, but I want the database on the webserver. I appreciate any direction or guidance. sincerely, Lamar --------------------------------------------------------------------- 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