MxLoader

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
------------------------------

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.
------------------------------

Thank you. I will look into your suggestion.

Stevie

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

Original Message:
Sent: 01-31-2023 16:34
From: Christopher Winston
Subject: MxLoader 8.3.5 Microsoft Visual Basic Run-time error '13' Type mismatch

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.
------------------------------

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
------------------------------

Original Message:
Sent: 01-31-2023 16:34
From: Christopher Winston
Subject: MxLoader 8.3.5 Microsoft Visual Basic Run-time error '13' Type mismatch

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.
------------------------------