[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

Excel SQL - Link to a SQL database table

Posted on 2011-09-07
2
Medium Priority
?
245 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:Murray Brown
2 Comments
 
LVL 39

Accepted Solution

by:
nutsch earned 2000 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:Murray Brown
ID: 36499387
Thanks very much
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

Question has a verified solution.

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

You need to know the location of the Office templates folder, so that when you create new templates, they are saved to that location, and thus are available for selection when creating new documents.  The steps to find the Templates folder path are …
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

834 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