shane07 Posted October 1, 2007 Share Posted October 1, 2007 Is it possible to transfer the whole data from excel sheet to the mysql database? Link to comment https://forums.phpfreaks.com/topic/71352-solved-transferring-excel-data-to-mysql-table/ Share on other sites More sharing options...
d.shankar Posted October 1, 2007 Share Posted October 1, 2007 A clean tutorial with screenshots. http://www.webthang.co.uk/tuts/tuts_dbase/convert/convert.asp Link to comment https://forums.phpfreaks.com/topic/71352-solved-transferring-excel-data-to-mysql-table/#findComment-359077 Share on other sites More sharing options...
shane07 Posted October 2, 2007 Author Share Posted October 2, 2007 Thanx for ur suggestion Actually I want to use PHP to transfer data from excel sheets to MySql database. I heard that csv should be used to do this. But I don't know what is csv. Link to comment https://forums.phpfreaks.com/topic/71352-solved-transferring-excel-data-to-mysql-table/#findComment-359888 Share on other sites More sharing options...
MadTechie Posted October 2, 2007 Share Posted October 2, 2007 a CSV is a comma-separated values file format, Excel can be saved as a CSV file PHP & CSV, hope this helps Link to comment https://forums.phpfreaks.com/topic/71352-solved-transferring-excel-data-to-mysql-table/#findComment-359890 Share on other sites More sharing options...
MadTechie Posted October 2, 2007 Share Posted October 2, 2007 Oh i forgot MySQL & CSV try this LOAD DATA LOCAL INFILE '/importfile.csv' INTO TABLE test_table FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n' (field1, filed2, field3); Link to comment https://forums.phpfreaks.com/topic/71352-solved-transferring-excel-data-to-mysql-table/#findComment-359891 Share on other sites More sharing options...
shane07 Posted October 2, 2007 Author Share Posted October 2, 2007 Well. Thanx for ur reply Link to comment https://forums.phpfreaks.com/topic/71352-solved-transferring-excel-data-to-mysql-table/#findComment-359897 Share on other sites More sharing options...
d.shankar Posted October 2, 2007 Share Posted October 2, 2007 If your query is finished then click Topic Solved and do credit MadTechie Link to comment https://forums.phpfreaks.com/topic/71352-solved-transferring-excel-data-to-mysql-table/#findComment-359904 Share on other sites More sharing options...
MadTechie Posted October 2, 2007 Share Posted October 2, 2007 LOL , (s)he offline.. oh well Link to comment https://forums.phpfreaks.com/topic/71352-solved-transferring-excel-data-to-mysql-table/#findComment-359912 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.