Re: Excel to MySQL
| From: | Jadiel Flores | Date: | Fri, 09 May 2003 15:27:52 +0000 |
| Subject: | Re: Excel to MySQL | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-27616@lists.php.net to get a copy of this message | ||
You could export your xls to csv and create a little script to read the values in the files and insert them into the DB.
At 04:21 PM 5/9/2003 +0100, you wrote:
Hi, I have some data in an Excel spreadsheet that i need to uplaod to a MySQL Database, is there any way to do this i.e. formatting each cell so there qoutes around each entry, exporting to a text file etc Thanks for your help -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.phpJadiel Flores ------------------------- http://www.abargon.com jflores@abargon.com (52-55) 52-29-80-34