Advertise with us

Export Excel data to Gridview

Hi All,

To Export excel  data to gridview,I got  the error message like this
The Microsoft Office Access database engine could not find the object 'Sheet1$'.  Make sure the object exists and that you spell its name and the path name correctly.

         MyCommand = new OleDbDataAdapter("select * from [Sheet1$]", MyConnection);
         DtSet = new DataSet();
         MyCommand.Fill(DtSet,"[Sheet1$]");

Thanks in advance
Htwe Htwe
Last updated:10/3/2013 8:58:08 AM

0 Answers

Answer