By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
434,742 Members | 2,044 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 434,742 IT Pros & Developers. It's quick & easy.

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

P: 19
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.
Jun 7 '08 #1
Share this Question
Share on Google+
3 Replies


P: 5
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_id=31
Jun 7 '08 #2

Atli
Expert 5K+
P: 5,058
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.
Jun 7 '08 #3

P: 19
Thanks a lot !! I have done huge data analyis tasks (CSV to MYSQL) using this help. Thanks again..!!
Dec 27 '08 #4

Post your reply

Sign in to post your reply or Sign up for a free account.