mike1 Posted August 9, 2007 Share Posted August 9, 2007 i have developed a website using php and mysql.The problem is that i want to know how can i import data using the excel sheet into mysql.i mean i have a link in the admin section where the admin will select the file and upload it.then all the data in the excel sheet should be pumped into the mysql database ???.Any help would be greatly appreciated. thank you mike1 Quote Link to comment Share on other sites More sharing options...
HuggieBear Posted August 9, 2007 Share Posted August 9, 2007 You could export the excel spreadsheet as a CSV file then use fgetcvs() or alternatively you could probably use COM objects. Regards Huggie Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.