I'm using OLEDB to export data from Excel sheet to table in oracle DB.
I connected to oracle DB with success, I executed the insert command to table, the row is inserted but the field is blank when the value passed is variable. have you any experience on that?
Dim meter_dcs As String
meter_dcs = "Compteur"
strSQL = "INSERT INTO r5readingsinterface (rei_meter, rei_object) values ( '" & meter_dcs & "' , 'OBJECT') "
the result after inserting :
select rei_meter, rei_object from r5readingsinterface
the question is why the rei_meter is blank?