kamal213 Posted August 8, 2011 Share Posted August 8, 2011 Hi Guys, I would like to know if it is even possible to import an EXCEL file into you mysql database table. Thanks Link to comment https://forums.phpfreaks.com/topic/244211-mysql-excel-import/ Share on other sites More sharing options...
fenway Posted August 8, 2011 Share Posted August 8, 2011 Everything is possible -- LOAD DATA works well, assuming you have a real Excel file with known delimeters. Link to comment https://forums.phpfreaks.com/topic/244211-mysql-excel-import/#findComment-1254235 Share on other sites More sharing options...
kamal213 Posted August 8, 2011 Author Share Posted August 8, 2011 Thanks for your reply. Do I need to create another table in my database which has the field indentical to the excel file or is a case of clicking on LOAD DATA and it imports automatically? Thanks Link to comment https://forums.phpfreaks.com/topic/244211-mysql-excel-import/#findComment-1254243 Share on other sites More sharing options...
fenway Posted August 8, 2011 Share Posted August 8, 2011 There is nothing "automatic" -- you map the fields to an existing table as you see fit. Link to comment https://forums.phpfreaks.com/topic/244211-mysql-excel-import/#findComment-1254260 Share on other sites More sharing options...
kamal213 Posted August 8, 2011 Author Share Posted August 8, 2011 Correct! I just tried it out and I have been able to import!!!!!!! Thanks for your help Link to comment https://forums.phpfreaks.com/topic/244211-mysql-excel-import/#findComment-1254265 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.