unable to import excel 2007 to sql server using openrowset function

I want to import records in excel 2007 to sql server 2005 table. I used the query following query to select the reocrds.

select * 
FROM OPENROWSET ('Microsoft.ACE.OLEDB.12.0' ,'Excel 12.0;Database=d:\input.xlsx' ,
                 'SELECT * FROM [a$]' )

The开发者_如何转开发 query is running long time without any error or result. Then I convert the file to .xls format and used the following query.

select * 
FROM OPENROWSET ('Microsoft.JET.OLEDB.4.0' , 'Excel 8.0;Database=d:\input.xls' ,
                 'SELECT * FROM [a$]' )

It displayed the records.

But in most of the scenario, I should use .xlsx extension. Because the no. of records in a sheet may be huge.

Please help me.

Thanks, P.Gopalakrishnan

---

Go to ServerObjects Then LinedServers Then Providers If the name of the Provieder is not in the List then It will Give Error Of Provider.