MxLoader

 View Only
  • 1.  MxLoader 8.3.5 Microsoft Visual Basic Run-time error '13' Type mismatch

    Posted 01-31-2023 15:16
    Hi, I'm seeking some MxLoader 8.3.5 help for a Microsoft Visual Basic Run-time error '13' Type mismatch. Does anyone know how to fix this error?


    Thanks

    ------------------------------
    Stevie Holloway
    Tufts University
    ------------------------------


  • 2.  RE: MxLoader 8.3.5 Microsoft Visual Basic Run-time error '13' Type mismatch

    Posted 01-31-2023 16:34
    I don't recall this error message, but I do recall having mismatches in the data based on the type of the field I am loading to, especially when it is an extra field and it perhaps requires a number and for some reason, way down in the sheet, I have a record or two that has a letter in it. So, you need to validate the data of each cell to the type of data in the field you are populating.

    ------------------------------
    Christopher Winston
    Projetech Inc.
    ------------------------------



  • 3.  RE: MxLoader 8.3.5 Microsoft Visual Basic Run-time error '13' Type mismatch

    Posted 01-31-2023 16:54
    Thank you. I will look into your suggestion.

    Stevie

    ------------------------------
    Stevie Holloway
    Tufts University
    ------------------------------



  • 4.  RE: MxLoader 8.3.5 Microsoft Visual Basic Run-time error '13' Type mismatch

    Posted 02-01-2023 09:31

    Hi Christopher,

    The time zone value caused the issue on the config tab. It conflicted with the reported date in my query. I removed the time zone value and no longer have the issue.



    ------------------------------
    Stevie Holloway
    Tufts University
    ------------------------------