how to read excel file from the data base
how to read excel from the database.
Dim ExcelObj As New Excel.ApplicationClass
ExcelObj.Visible = True
Dim wb As Excel.Workbook = ExcelObj.Workbooks.Add(XlWBATemplate.xlWBATWorksheet)
ElseIf strVal = "xls" Then
wb = ExcelObj.Workbooks.Open(FILENAME)
ExcelObj.Workbooks(1).Activate()
EntireFile = wb.ReadOnly
IT SHOW THE ERROR " System.Runtime.InteropServices.COMException: Old format or invalid type library."
plz tell me