Via the import/export wizard I can readily import the Excel file. I copied the connection string from the generated SSIS file and tried that in my query window and I have the same non-descript error. I even (thinking it was a permission error ) changed the system TMP and TEMP values to point to c:\tmp and changed the permission to EVERYONE. It had no affect.