Solved

Excel SQL - Link to a SQL database table

Posted on 2011-09-07
2
230 Views
Last Modified: 2012-06-27
Hi

Is it possible in Excel 2007 to link to a SQL database in order to make changes to it?

Thanks
0
Comment
Question by:murbro
2 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 500 total points
ID: 36499333
Yes and no. You can make changes in Excel to SQL server, but it requires running a macro that will either call a SQL command (UPDATE WHERE) or a stored procedure with parameters.

You cannot pull a table using query from SQL, update in excel and have the updates automatically done in SQL.

T
0
 

Author Closing Comment

by:murbro
ID: 36499387
Thanks very much
0

Featured Post

What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

Join & Write a Comment

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
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…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

747 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

11 Experts available now in Live!

Get 1:1 Help Now