Please help with an Excel connection string to MSSql

[beetlebailey]

I have an Excel worksheet, (Sheet1) that I want to copy the data in cells B3:B12 into a SQL database named VPD. I am using Excel to pull data from SQL thru an ODBC connection to the remote server and it works quite well. I cannot seem to get a handle on the correct connection string and open it in the VBA worksheet to the remote SQL server to perform the SQL update command.
SQL server=Administrator, System DSN=VPD, Database=VPD
Thanks so much.

 

[jbenson001]

Do you want to copy the excel sheet into your DB then run an update? Is that the question?

 

[beetlebailey]

I want Excel VBA to open a connection to SQL, then perform an update of the data contained in cells B3:B12 to the SQL database VPD then close the connection.

 

[cmmrfrds]

This site has connections strings for almost any data source.

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMySQL

 

[jbenson001]

How about pulling in the values from the spread sheet into a table and using that table to update the other table? Then drop the first table.