What are the errors?

Have you tried importing it as Excel 97/2003 .xls format (instead of 2007)?

Also this may provide some insights (to use MS Office 12 OLE engine instead of Microsoft Excel)

http://www.sql-server-performance.com/articles/biz/How_to_Export_Data_to_Excel_2007_p1.aspx