forum

Home / DeveloperSection / Forums / Export Excel data to Gridview

Export Excel data to Gridview

Htwe Htwe190103-Oct-2013
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

Updated on 03-Oct-2013

Can you answer this question?


Answer

0 Answers

Liked By