471,825 Members | 1,021 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,825 software developers and data experts.

how can i import excel data into mysql

1
i need to import Excel data into Mysql database. How can i do it. Is there any utility or any script can do it. Thanks in advance.
Jan 12 '07 #1
4 12957
ronverdonk
4,258 Expert 4TB
Look at the following thread converting Excel to MySQL using PHP in this forum.

Ronald :cool:
Jan 12 '07 #2
The simplest way to use Excel imports and exports with PHP is to use the PEAR Excel functions. I've just finished working on a project where I've had to export to Excel directly from PHP, and another developer produced the import script, and it's all pretty easy wen you use this.
Jan 16 '07 #3
makana
1
The simplest way to use Excel imports and exports with PHP is to use the PEAR Excel functions. I've just finished working on a project where I've had to export to Excel directly from PHP, and another developer produced the import script, and it's all pretty easy wen you use this.
hiii can u please post or send me the code for pear excel function as i am new to this so could u please help me out in it thanks a lott in advance even u can mail the code to my id makanaashish@gmail.com thanku once again
Aug 14 '07 #4
jx2
228 100+
php do not have this function built in so you need to write it on your own or yous third parties resorses e.g see this website

regards
jx2
Aug 14 '07 #5

Post your reply

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

Similar topics

2 posts views Thread by Damien | last post: by
reply views Thread by Phil Perrin | last post: by
8 posts views Thread by Johnny | last post: by
reply views Thread by YellowAndGreen | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.