Users Pricing

forum

Home Forums Export Excel data to Gridview – MindStick

Export Excel data to Gridview

Htwe Htwe 2349 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

0 Answers

Markdown for AI

A clean, structured version of this page for AI assistants and LLMs.

Open .md