suresh babu

suresh babu

  • NA
  • 4
  • 0

how to read excel file from the data base

Sep 14 2005 6:27 AM

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