forum

home / developersection / forums / export excel data to gridview

Export Excel data to Gridview

Htwe Htwe 2169 03-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