like below fixes the issue I happen to find out the problem exists when you modify the xlsx file manually or programatically without using excel once you modify the xlsx the format doesn't stay intact and the above mentioned error comes up because OleDbDataAdapter is unable to handle the modified file and Excel it self can fix the corrupt files shows the file as expected.
Error = [Microsoft][ODBC Driver 11 for SQL Server]Warning: BCP import with a format file will convert empty strings in d
this one helps. Apparently,according to Microsoft this is not an error but just a warning and can be safely ignored.(Detailed discussion and work around here) In my case, I was parsing the BCP console output for string "Error" and reporting that the process failed. Since I am using the Process class of .NET framework to call the BCP command in C# code, I had to add code to check for process exit code 0 and suppress this specific warning.
Error: Failed to send Target is not set or not in URL format(Microsoft Teams)
this will help ODBC Driver and DSN information is stored in HKEY_LOCAL_MACHINE\SOFTWARE\ODBC registry key(user dsn info under HKEY_CURRENT_USER\SOFTWARE\ODBC). The error indicates that you do not have access to that registry key.