Junglee_George (1/13/2011)

Try this useful link

http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx%5B/quote%5D

:ermm:

Did you read the original question? The link you provided just explains how to import data from excel using the OPENROWSET command. The OP has already done that, there is a problem with the provider.

@divya-2: check if distributed queries are enabled in your db:

EXEC sp_configure 'ad hoc distributed queries'