Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 527
  • Last Modified:

EXCEL & working with external ODBC databases

Hi

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.

TX
0
shaunwingin
Asked:
shaunwingin
  • 3
  • 2
2 Solutions
 
netballiCommented:
0
 
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.
0
 
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.
0

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now