Sub SetLevel(stat As String, value1 As Double, value2 As Double, value3 As Double)
    
    ' Dim rst As ADODB.Recordset
    Dim rst As Object
    Set rst = CreateObject("ADODB.Recordset")
    
    Dim Cmd As New ADODB.Command
    With Cmd
        .ActiveConnection = oConn         'is set before sub is called
        .CommandText = "dbo.SetLevels"
        .CommandType = adCmdStoredProc
        .Parameters.Refresh
        .Parameters("@stat") = stat
        .Parameters("@level1") = value1
        .Parameters("@level2") = value2
        .Parameters("@level3") = value3
        Set rst = .Execute
    End With
    
End Sub

ALTER PROCEDURE [dbo].[SetLevels]
	@stat varchar(64),
	@Level1 float,
	@level2 float,
	@level3 float
AS
BEGIN

	SET NOCOUNT ON;

	UPDATE dbo.Levels
		SET T1 = @level1, 
		    T2 = @level2, 
		    T3 = @level3
		WHERE stat = @stat
	;
END

quote:

---

Originally posted by nigelrivett

Depends on what your environment is like. Do yoou want to run this from excel or use a spreadsheet as input?
The easiest way is to generate insert statements in excel, copy them to a query window and run them

How you generate the insert statements is up to you, you could do it in script looping through the columns (then you might as well put the execute there as well) and add a button to run it.
I tend to do it in a formula in each row - you would probably generate the formula for that many columns.

You might want to use ssis if it is something that is going to be delivered regularly.
Could also use a linked server to import.
Could export to a csv then import using bulk insert

Lots of ways

==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.

---