avijit Posted March 30, 2009 Share Posted March 30, 2009 How can i retrieve data from excel sheet to Mysql ? Can anybody have any idea , please explain ? Quote Link to comment Share on other sites More sharing options...
taquitosensei Posted March 31, 2009 Share Posted March 31, 2009 save as a csv then use load data infile http://dev.mysql.com/doc/refman/5.1/en/load-data.html Quote Link to comment Share on other sites More sharing options...
Mark Baker Posted April 2, 2009 Share Posted April 2, 2009 How can i retrieve data from excel sheet to Mysql ? Use a library such as PHPExcel Quote Link to comment Share on other sites More sharing options...
fenway Posted April 3, 2009 Share Posted April 3, 2009 Or use the CSV engine type. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.