Excell/CSV files type data need to insert in MySQL database using php

[ahmurad]

Dear brothers,

I have some importnat files in MS Excell / CSV format. I know php. I want to insert these files into MYSQL database to generate reports.

What are the techniques to insert the MS Excell / CSV files into MySQL?

Your kind quick reply is highly appreciated.

[Justummar]

Removed link to a competing forum.

Try this, I think this is what you are looking for.
<link removed>

http://dev.mysql.com/doc/refman/5.0/en/load-data.html

http://russell.dyerhouse.com/cgi-bin/article.cgi?article_id=31

[Atli]

PHP has no support for the proprietary M$ formats, such as Excel spreadsheets and Word documents.

If you can export them into CSV or XML, PHP and/or MySQL can handle them easily via the LOAD DATA INFILE (see Justummar's link) or PHP's SimpleXML package.

P.S.
Justummar, please don't post links to competing forums. Especially if they have their members to pay for access.
Please check out the Posting guidelines for more.

[ahmurad]

Thanks a lot !! I have done huge data analyis tasks (CSV to MYSQL) using this help. Thanks again..!!