Solved

EXCEL & working with external ODBC databases

Posted on 2013-07-02
5
521 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
 

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

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

688 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