Connection to SQLServer in macro

[#1]

I have moved data from Access to a MS SQLServer and can easily get in contact with the data in the script writing

ODBC CONNECT TO SQLServer;

Load FIELD;

SQL Select SUM FROM KirKliniskeData."Score_mdb".TABLE

Question:

How can I set up a connection updating the table in the macro ??

set oconn = CreateObject("ADODB.Connection")

oconn.open ????

UpdateString = "INSERT INTO TABLE SUM VALUES (' '" & xSUM & " ' ) "

when I get the Connection string right, I think the Dynamic Upload command will also work as in previous access connection

Thanks for any help

Einar