*^*JUNAID*^* wrote: > Thanks for your file > I want a php script for that because My client want this option in his > website. > Thanks waiting for your reply > > */Brian Cummiskey <brian@xxxxxxxxxxxxx>/* wrote: > > *^*JUNAID*^* wrote: > > Hello > > I want to import data from MS excel file to phpmyadmin using > PHP.I have the code using COM class but this works only on windows > plate form.My hosting server is linux so when i upload it to that > server(the same script) then HTTP 500 Internal server error. > > Can any one tell me how can do the same on Linux server. > > waiting for your help > > If any one already have done this script then I appreciate if > he/she should share. > > thanks > > > > open the XLS > > file->save as > > and convert it to a CSV > > you can import CSV's via phpmyadmin. > I don't think there is any getting around converting the XLS to a CSV. Excel carries a lot of (useless to a database) bulk. Once it's in a CSV, there's built-in functions in php to handel a csv upload. http://ca.php.net/manual/en/function.fgetcsv.php ------------------------ Yahoo! Groups Sponsor --------------------~--> Most low income households are not online. Help bridge the digital divide today! http://us.click.yahoo.com/cd_AJB/QnQLAA/TtwFAA/saFolB/TM --------------------------------------------------------------------~-> PHP Data object relational mapping generator - http://www.meta-language.net/ Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/php-objects/ <*> To unsubscribe from this group, send an email to: php-objects-unsubscribe@xxxxxxxxxxxxxxx <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
