Re: Excel to MySQL
| From: | Richard Baskett | Date: | Fri, 03 Jan 2003 21:29:30 +0000 |
| Subject: | Re: Excel to MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-130156@lists.php.net to get a copy of this message | ||
You could export, or save as a tab delimited text file, then go ahead and
use phpMyAdmin or a custom script to pull all that data into the database.
It really shouldn¹t be much of a problem coming from Excel.
Cheers!
Rick
"Finish each day and be done with it. You have done what you could; some
blunders and absurdities have crept in; forget them as soon as you can.
Tomorrow is a new day; you shall begin it serenely and with too high a
spirit to be encumbered with your old nonsense." - Ralph Waldo Emerson
> From: Joe LoMoglio <joe@jlcreative.net>
> Date: Fri, 3 Jan 2003 14:20:02 -0700
> To: php-general@lists.php.net
> Subject: [PHP] Excel to MySQL
>
> Does anyone know of a FREE utility that will export data from an MS
> Excel file and import it to MySQL. I have found a bunch of nice
> utilities, but none of them are FREE. I'm in a bind and have to get
> over 2000 rows imported to my database by morning and don't have to
> order one of the other solutions.
>
> Joe LoMoglio
>
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>
>