Re: Excel to MySQL??
| From: | Chase | Date: | Sat, 29 Jun 2002 21:56:54 +0000 |
| Subject: | Re: Excel to MySQL?? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-20207@lists.php.net to get a copy of this message | ||
My webhost is running phpMyAdmin v2.2.2 and it is giving me errors when I try to load the file. Are there any certain characters that cannot be in the file? (ie. "$")
Chase
Peter Lovatt wrote:
Hi from Excel export to csv use phpMyAdmin to load it into mysql (recent versions of phpMyAdmin has an Excel import function) HTH Peter ----------------------------------------------- Excellence in internet and open source software ----------------------------------------------- Sunmaia www.sunmaia.net info@sunmaia.net tel. 0121-242-1473 ----------------------------------------------------Original Message----- From: Chase [mailto:chase@ck2000.biz] Sent: 29 June 2002 22:22 To: php-db@lists.php.net Subject: [PHP-DB] Excel to MySQL?? Does anyone know of a way that I can export an Excel spreadsheet to a file that I can import to MySQL? I found a program that will do this for Access, but I would rather leave Access out of this if possible. Thanks!! Chase -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php