EXCEL & working with external ODBC databases


We have a MySQL database & we are able to connect to it within excel.

What functionality is available?
Can one edit to the data?
Perhaps you can sent me a link to follow with a tutorial to illustrate this.

Who is Participating?

Improve company productivity with a Business Account.Sign Up

shaunwinginAuthor Commented:
tx. What functionality is offered nativly by MS Excell version 2010 and 2013 as regards actually editing the data. I can get it to display the data without an issue.
shaunwinginAuthor Commented:
Tx. Can you assist with installation of this https://blogs.oracle.com/MySqlOnWindows/entry/introducing_mysql_for_excel
I've installed the Workbench but no Add-in visible in Excell 2010.
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.