I want to export the data from sql toexcel.

I do The following procedure

First i m enableing ad hoc then

Create linked server and after that i have created excel file with header which is one of the column name of my table and then run a query Of select * from openrowst
but i get an error of "Can not Initialize the Data source object of oledb Provider Microsoft.jet.o ledb.provider.4 .0 for...