Insert empty column of excel into sql

could you please suggest to me which one should I install?

@Cuberoot

Odbc are better…go with them…

Cheers

i guess its package issue. in UiPath database activities 1.7.1 we cannot use oracle database client. i am facing another issue in execute non query i.e 06/11/2023 07:25:44 Value cannot be null. (Parameter ‘At least one of the connections must be used.’)

@Cuberoot

As per error i can see you did not use any connection in execute query

Cheers

I have found solution it is throwing the error because some columns are empty.I am facing one issue in the empty cell of every row I want to write na.how to do it?

@Cuberoot

  1. For each row in datatable on dt
  2. For each activity with dt.Columns and type argument as datacolumn
  3. If condition with IsNothing(currentrow(currentitem.ColumnName)) OrElse String.IsNullOrEmpty(currentrow(currentitem.ColumnName).ToString)
  4. Else side use assign with currentrow(currentitem.ColumnName) = "NA"

Cheers