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 Quote 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. Quote 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 Quote 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. Quote 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 Quote Link to comment https://forums.phpfreaks.com/topic/244211-mysql-excel-import/#findComment-1254265 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.