Junglee_George (1/13/2011)
HiTry this useful link
http://beyondrelational.com/blogs/madhivanan/archive/2007/08/27/import-export-to-excel.aspx
: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'
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP