Using ADO to INSERT Named Range Values into DB

Is there a way that I can insert the contents of a named range within
Excel into a SQL Server database using ADO?

Assuming you already know how to insert values into a sql server table,
you would simply have to refer to the value property of the range name.

In this example, test is a global range name; department is a field within a
sql server table.

..Fields("department") = Range("test").Value

This did not work.