Export Excel data to Gridview

Total Post:3


 1536  View(s)
Rate this:
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();

Thanks in advance
Htwe Htwe


Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.