Hello All,
I am reading a xls file and displaying the content of the file in gridview using olddbprovider. But It ignores the very first row of the excel file B'coz it treat the first line as column heading. Could anybody tell me how can i read very first row.

Thanks in Advance.

You can specify whether to read the first row as data or column headers in your connection string. If you're using the jet driver to connect, you might want to specify whether or not to include the header row. Check this out:

http://www.codeproject.com/database/...OLE%20DB%20Jet

Check out the part about putting HDR=Yes/No in the extended properties section. That might help you out.

Neil Timmerman
Programmer
Veris Consulting