RE: [PHP-DB] Importing Excel and Access data to MySQL
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
RE: [PHP-DB] Importing Excel and Access data to MySQL
-Original Message- From: Matthew Perry [mailto:[EMAIL PROTECTED] Sent: Friday, October 08, 2004 8:16 AM 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 Please search for previous posts in the list. This topic discussed several times in the list. Googling also can help you. Zareef Ahmed = Zareef Ahmed :: A PHP Developer in Delhi ( India ) Homepage :: http://www.zasaifi.com --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.769 / Virus Database: 516 - Release Date: 9/24/2004 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php