how to import excel file in mysql database

[powerofphp]

hello
i want to import microsoft excel file in mysql database , is it possible in php language????

plz help in this regards

[edwardsbc]

Export the Excel file as a CSV (comma separate values) file. Then you can load the file in to an array with file(). Once you've done that, loop over the array with foreach() to access each row (of the original excel file). Explode() will help you break up the elements.