Results 1 to 1 of 1
  1. #1
    Join Date
    Nov 2003

    Arrow Unanswered: Incompatible version of the RPC stub


    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)
    end sub

    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

    Attached Thumbnails Attached Thumbnails autmn_err.jpg  

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts