0

I am trying to make a select in firebird according to the value it has in an excel range.

I use a for to go through the column, I only have a problem printing the select, it only prints the first value it finds. I appreciate your help

  Dim F As New ADODB.Recordset
    vDB = Ws.Range("a1").CurrentRegion
For i = 2 To UBound(vDB, 1)
Set F = con.Execute("SELECT EXISTENCIA FROM CATINVEN WHERE PRODUCTO = '" & vDB(i, 2) & "'  ")
           Worksheets("1").Cells(3, 2).CopyFromRecordset F
braX
  • 11,506
  • 5
  • 20
  • 33

0 Answers0