Solved

EXCEL & working with external ODBC databases

Posted on 2013-07-02
5
505 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

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;…
Does the idea of dealing with bits scare or confuse you? Does it seem like a waste of time in an age where we all have terabytes of storage? If so, you're missing out on one of the core tools in every professional programmer's toolbox. Learn how to …
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.

705 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now