How to Import Excel Data Into MySQL Table

hello there I would like to show you a really quick and simple way for bringing data from Excel into my sequel first of all I have a workbook here that a Miss data and the only sheet available here the name is employee info so I have a table with the same name is important and as you can see here the structure of this table matches perfectly the structure of this fresh sheet now only one thing I'm gonna do before bringing the data I'm going to format this dates appropriately let me just do that right now and done so using the prefer format for my sequel now the trick here I'll save this workbook as an open document spreadsheet right here okay I'm gonna give it another name open doc okay it's done they gonna tell me that you may contain features that are not compatible with this format which is fine yes save coming into phpMyAdmin then here I have no data I'm going to move into the import section here just file go and look for that file open make sure I tell it that the first line of the file contains the table column names go it's that simple that's simple I have my data now you tell me well I do not have a table I do not have a table I want to bring the data but I do not have a table created that's fine no problem I'm going to actually delete this table but before I do that I like to show you something you can look at the structure I had a structure here and birthday date and so on if you don't have a table it's not gonna respect it's not going to actually create the structure this the way you might want it you might need to go and do some cleanup but still it saves you a whole lot of time doing it that way if you don't have a table created already so I'm going to delete the table gone import again just file data open same thing the first line of the file contains the table call names go I have my data here and you can see the sequel statement right here it's pretty much telling it if the table doesn't access create it so it's right here and it uses the fields then feels now you can take a look at the structure you didn't bring the dates at stake but you can just go ahead and just clean it up and and you're done no time less than a minute and you're done it doesn't matter how many fields it's done thank you for your time

Channel: Edward Lara

Views: 64,217

Rating: 4.8645067 out of 5

Keywords: excel, mysql, data, transfer, sql, info, easy, learning, tutorial, Edward Lara, tip

Id: nVhhoGoTNuA

Length: 2min 53sec (173 seconds)

Published: Thu Jan 19 2017