Forum Discussion

CLCastroEn's avatar
CLCastroEn
Icon for Helper IV rankHelper IV
5 years ago

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 b...
mahoneypat's avatar
mahoneypat
Icon for Microsoft Employee rankMicrosoft Employee
5 years ago

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