Iam trying to upload data from Excel to Sql Server.
Iam not using DTS.
Code for the error goes like this
Dim xlapp As New Excel.Application
Dim xlbook As New Excel.Workbook
Dim xlsheet As New Excel.Worksheet
Private Sub btn_Upld_Click()
Set XlWBook = xlapp.Workbooks.Open(txtFileName.Text)
Set xlsheet = XlWBook.Worksheets(1)
Previously the same code was working in a windows '98 machine as well as XP machine , now in Windows 'NT machine if executed, the file name of the application gets assigned to the workbook , the next line that sets the xlsheet to the workbooks(1) gives the error :
Runtime error -2147023067 (80070725) Incompatible version of the RPC stub