yubaraj Posted March 14, 2007 Share Posted March 14, 2007 Hello everyone,I need to import excel sheet in the site and change the mysql database according to the data in the excel format.How is it possible?Can anyone give me some of the ideas how to do it.Thank You Link to comment Share on other sites More sharing options...
PrateekSaxena Posted March 14, 2007 Share Posted March 14, 2007 Idea : first save the excel as csv and then upload the filenext write a PHP program to read csv an input in MySQL Link to comment Share on other sites More sharing options...
Nakor Posted March 14, 2007 Share Posted March 14, 2007 There's no real need to write a PHP script to read the CSV file as long as you have PHPMyAdmin. There is an option there to import a CSV file. If not look into the fgetcsv() function. Link to comment Share on other sites More sharing options...
PrateekSaxena Posted March 14, 2007 Share Posted March 14, 2007 Get phpMyAdmin here! Link to comment Share on other sites More sharing options...
yubaraj Posted March 15, 2007 Author Share Posted March 15, 2007 Thank You for your idea,The idea seems perfectly fit and since i am a new in such things, Can u tell me , how to change the excel file into CSV Format.Thank You Link to comment Share on other sites More sharing options...
PrateekSaxena Posted March 15, 2007 Share Posted March 15, 2007 File > Save As > Save As Type > CSVGive the name and then save it! Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now