one other thing that I forgot to mention - you need to install either Excel 2007 on the server that you are executing on or download the AccessDatabaseEngine driver from

http://www.microsoft.com/downloads/details.aspx?familyid=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en

also remember that when you run these queries via Management studio, the source files must be on server themselves.

you cannot connect to a local instance of SQL and execute against files not on your local machine.