Re: How to add an excel file directly to MySQL database using PHP?
| From: | Joel Ricker | Date: | Sat, 04 Aug 2001 05:26:45 +0000 |
| Subject: | Re: How to add an excel file directly to MySQL database using PHP? | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-61222@lists.php.net to get a copy of this message | ||
> How can I add an excel file with *.xls extension
> directly into MySQL database..is it possible to do or
> I need to convert it into *.csv format or *.txt format
> first?
Yes you will need to save it as a .txt file. Excel will prompt you for how
you want to delimit your text. Commas are about the easiest way. Are you
using phpMyAdmin? I know it has a built in function to import a comma
delimited (or anything-delimited for that matter) text file. I'm sure other
MySql managers support it as well.
If PHP is your only interface to MySQL let me know and I'll try and provide
you with the code you need.
Joel