Database Management Excel

[lrnrxl]

Hello everyone! I am new to the forums and hope to learn a lot. Thanks in advance for taking your time to read the question and providing me with assistance. I am also currently researching the issue myself.

I am currently working with a MySQL database and would like to somehow edit it and select data from it through Excel. My main needs would be able to download the information and then to upload the information from the spreadsheet to the database if necessary. Does anyone know what is the best way to do this.

I see that in the data tab there is a place to connect to the database but it has been difficult for me to use and I made errors when trying to upload. Is there any excel management software for MySQL that I can find that will help me? Or should I abandon my efforts to try and work with the database on a spreadsheet?

Any help from people with experience on this issue would be helpful,

 

[lrnrxl]

So just an update. I found a software from MySQL built specifically for Excel - a godsend! Found it on their site and couldn't be happier. I am hoping it will work. However, a friend of mine who is a developer recently told me that he never uses spreadsheets to work with MySQL so perhaps I shouldn't be so confident ...