Excel SQL - Link to a SQL database table

Hi

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

Thanks
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAsked:
Who is Participating?
 
nutschCommented:
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
 
Murray BrownMicrosoft Cloud Azure/Excel Solution DeveloperAuthor Commented:
Thanks very much
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.