Hi there,

I am struggling trying to get write changes to an SQL server from Excel. I am of course able to get the data from SQL into Excel easily through a query, but what I want is a button that I can press that can run a macro that will write changes to SQL.

The table is simple, it just has 3 columns: Code, Notes and Responsibility, the query looks like such:

SELECT usr_Notes.Code, usr_Notes.Notes, usr_Notes.Responsibility
FROM Database.dbo.usr_Notes usr_Notes

and my connection string as follows:

DSN=*******;UID=*******;Trusted_Connection=Yes;APP=Microsoft Office 2010;WSID=*******;DATABASE=*******

I know there are add ins that can make this work, but I really want to rely on add ins as there would be many different people accessing the document and from the add ins I have seen so far they don't seem very flexible. I have found websites like this:

http://www.toadworld.com/platforms/s...-in-excel.aspx

that explain what to do, but I am just not advanced enough to make it work. That is, I am not sure how to translate my simple connection settings and query into the example they have given to make it work.

Your help is much appreciated!