How to import data from excel file to mysql?

Author

Message

samir

Post subject: How to import data from excel file to mysql?

Posted: Fri Jun 12, 2009 5:55 am

Joined: Mon Nov 12, 2007 10:12 am
Posts: 355

We can use the following link to download the code regarding the excelreader
http://sourceforge.net/projects/phpexcelreader

1)download the files and unzip the files to your site
2)In the excel folder , open the file reader.php and change the line as
require_once 'Excel/oleread.inc';
3)now we have 2 examples written , we can write the sql query in the for loop itself

thanq

Top

Page 1 of 1

[ 1 post ]

Page 1 of 414

1, 2, 3, 4, 5 ... 414

	Replies	Views	Last post
Add Slide Notes & Images as Logos in MS PowerPoint by aspose » Tue May 21, 2013 4:03 am in Miscellaneous	0	16	Tue May 21, 2013 4:03 am aspose
Jquery ajax Pagination using php by rajkumar » Tue Apr 19, 2011 11:14 am in Coding Repository	8	17619	Mon May 20, 2013 2:46 am gfsdfg
Ecommerce website development and website Design by iweballey » Fri May 17, 2013 7:15 am in PHP-Code Help	0	341	Fri May 17, 2013 7:15 am iweballey
How to upgrade and migrate Joomal site by mallikharjuna rao » Mon Jan 21, 2013 1:40 pm in Joomla	1	361	Thu May 16, 2013 9:53 am sunitha12
Benefits of PHP by hirephpexpert » Fri Sep 07, 2012 4:41 am in CakePHP	6	1600	Wed May 15, 2013 6:25 am PrettyPrincesG

Other Forums

Other Services

Search