Glen

I have already changed it to 8.0 instead of 5.0.

I have tried using a linked server and got the same error. I have 50 excel spreadsheets that need to be updated from SQLServer. I was looking at the book SQLServer 2005 bible where they discuss accessing excel using opendatasource. I was thinking this could be the solution to my problem. If there is a better way to get that done I am open to other suggestions. I also tried openrowsource and got the same error.

Thanks

Quinn