Hi,
   I have a problem while reading Excel Data.
I have Excel Sheet names as 'Sales.xls' which does not contain grids in that file.
While reading this file i am getting an error External Table is not in Expected Format.
I have copied the data in 'Sales.xls' file to a new file named 'sales1.xls'.This file contains grid lines. I am able to read 'sales1.xls'.
Is any why of converting 'Sales.xls' file to 'Sales1.xls'. i.e Excel file without Grids to ExcelFile with Grids.

          I have used oledb,C#.Net
                  I will be thankfull on advice.