Re: import the excel data into mysql .

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hi,

You could remove the need for PHP all together and have instantaneous import
simply by creating a MySql table of type "CSV" with a field for each column
in the table.  Then save the excel sheet as csv and copy it to the MySql
data directory.  Bonus: you can use sql to CRUD it.  nice.

Hope this helps.


On Fri, May 20, 2011 at 9:08 PM, Roger Head <headrog@xxxxxxxxx> wrote:

>
>
> Hi,
> Can anyone help?
> I want the php code to import the excel data into mysql .
>
> Roger Head www.nlscoreboard.com
>
> From: "php-objects@xxxxxxxxxxxxxxx" <php-objects@xxxxxxxxxxxxxxx>
> >To: php-objects@xxxxxxxxxxxxxxx
> >Sent: Sunday, September 19, 2010 7:37:56 AM
> >Subject:  File - JSClasses.txt
> >
> >
> >
> >
> >Hello,
> >
> >Welcome to the PHP Objects mailing list.
> >
> >This list is mainly for discussing PHP related topics between users of the
> PHPClasses site. JavaScript related topics are tolerated but keep them
> related with PHP development. Discussions about other languages are not
> tolerated. Find another list to discuss those topics.
> >
> >Talking about JavaScript, if you are looking for useful JavaScript
> components, you may want to take a look at the JSClasses.org site. It is
> derived from the PHPClasses site except that it is for JavaScript objects.
> >
> >http://www.jsclasses.org/
> >
> >Look here for the latest objects that were published:
> >
> >http://www.jsclasses.org/browse/latest/latest.html
> >
> >If you want to contribute with your own JavaScript objects, please read
> this article to learn about the submission rules in order to have your
> objects accepted:
> >
> >http://www.jsclasses.org/blog/post/1-The-JSClasses-site-is-launched.html
> >
> >Regards,
> >PHP-Objects moderator
> >
> >
> >
> >
> >(709)726-4323(home)  (709)690-9006(cell), (709)729-0481(work)
>
> [Non-text portions of this message have been removed]
>
>  
>


[Non-text portions of this message have been removed]


[Index of Archives]     [PHP Home]     [PHP Users]     [PHP Soap]     [Kernel Newbies]     [Yosemite]     [Yosemite Campsites]

  Powered by Linux