Newbie: Update From Excel

I am a newbie at SQL Server, but I do have a little experience from
Coldfusion. Here's my Question.

We have a database for our business. We sell products. and we get price
lists in excel format all the time. I am working with DTS and I would like to
set it up, so that I can format the spread***, properly and execute the
package. easy as 1,2,3 right?

Well I have tried many things from doing it in SQL DTS to Access, and
everything is a no go. I have limited SQL knowledge but here is of the things
I have tried and it seems to me it should work.

INSERT
INTO Product (ListPrice)
SELECT ListPrice
FROM
[Product$]
WHERE (ProductID = Product $ .ProductID)


.