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

    Arrow Unanswered: Incompatible version of the RPC stub

    Hai,


    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


    here,
    vijayanand.g
    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
  •