Solved

EXCEL & working with external ODBC databases

Posted on 2013-07-02
5
510 Views
Last Modified: 2013-07-02
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
Comment
Question by:shaunwingin
  • 3
  • 2
5 Comments
 
LVL 11

Assisted Solution

by:netballi
netballi earned 500 total points
ID: 39292730
0
 

Author Comment

by:shaunwingin
ID: 39292744
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
 
LVL 11

Expert Comment

by:netballi
ID: 39292778
0
 

Author Comment

by:shaunwingin
ID: 39292792
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
 
LVL 11

Accepted Solution

by:
netballi earned 500 total points
ID: 39292804
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

778 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question