The best way I have found is convert the data to a comma separated value file, use phpMyAdmin and insert the data into you database. A couple of things that you have to watch out for is the number of records that you are importing and that all your fields in your DB are of the correct format and length.
Mark A. Bomgardner Technology Specialist KLETC -----Original Message----- From: Matthew Perry [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 9:46 PM To: [EMAIL PROTECTED] Subject: [PHP-DB] Importing Excel and Access data to MySQL Simple question, How does one import excel and access data to MySQL? -- Matthew Perry -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
