Re: Not quite OT but maybe close... Help with MySQL
| From: | Daniel Brown | Date: | Wed, 08 Aug 2007 18:00:44 +0000 |
| Subject: | Re: Not quite OT but maybe close... Help with MySQL | ||
| References: | 1 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-260448@lists.php.net to get a copy of this message | ||
On 8/8/07, Jason Pruim <japruim@raoset.com> wrote:
> Hey everyone,
>
> I tried asking this question on the MySQL list but haven't gotten
> very many helpful responses... Does anyone know how to successfully
> import a excel file into MySQL (To make it on topic) Using PHP? I
> have tried using LOAD FILE in mysql and it just imports the first row
> of my excel file with no errors...
>
> Any ideas?
> --
>
> Jason Pruim
> Raoset Inc.
> Technology Manager
> MQC Specialist
> 3251 132nd ave
> Holland, MI, 49424
> www.raoset.com
> japruim@raoset.com
>
>
>
It is a MySQL question, you're right.... but are you trying to
load a CSV that you read in Excel, or is it in Excel format?
--
Daniel P. Brown
[office] (570-) 587-7080 Ext. 272
[mobile] (570-) 766-8107
Hey, PHP-General list....
50% off for life on web hosting plans $10/mo. or more at
http://www.pilotpig.net/.
Use the coupon code phpgeneralaug07
Register domains for about $0.01 more than what it costs me at
http://domains.pilotpig.net/.