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? Quote 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 Quote 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. Quote 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 Quote 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); Quote 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 Quote 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 Quote 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 Quote 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
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.