Forum Discussion
Error en cargar base OLE DB or ODBC eerror
Hello everyone!
I have a base that has approximately 100 excel files combined from a folder. The problem that when updating sends me this error : "OLE DB or ODBC error [DataFormat.Error] Cannot be converted to numeric...
Please help me because there are more than 20 columns and what I did to each column was replace errors with a 0 and I thought it had been fixed but still sends me that error.
Is there any way to know which column brings such an error? (as I said I have many columns and there are too many files, so identifying which one has the error is complicated)
6 Replies
Hi CLCastroEn ,
You can enable the ‘Column quality’ option to see if the column contains errors.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@v-lionel-msft hello, if I put replace all errors from all columns and still throw the same message when applying changes, what can be going on?
You probably have columns that show just numbers in the preview, but actually contain text values. When you do a full load it tries to convert those text values to number. You can do a Keep Errors step to troubleshoot, or make those columns text instead of number, load it all, and then see the text values in Data View.
Regards,
Pat
@mahoneypat is the step of maintaining errors?
Hi CLCastroEn ,
Try to select all columns and use "Keep errors" feature to check the errors.
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi CLCastroEn ,
Has your problem been solved?
Best regards,
Lionel ChenIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
