Excel to MySQL
| From: | Chris Payne | Date: | Wed, 17 Oct 2001 05:58:01 +0000 |
| Subject: | Excel to MySQL | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13410@lists.php.net to get a copy of this message | ||
Hi there everyone,
What is the best way to convert an Excel spreadsheet into a MySQL database? Should I save it as a
comma'd file or is there a better way? If I have to save it as a comma'd text file, is
there anything special I should do first?
I would normally enter the data manually on my server, but we are talking in excess of 15000+
entries here which is way too many to add manually.
Thanks for all your help.
Chris