rows are updating but last row of the excel sheet is not updating(changing)
Dim dbconn As New ADODB.ConnectionDim stDB, strConn
Dim totColumns, totRows, i, j, WDS_id
Dim prBatchName, prTableQry, inTableQry, prTableQry1, dbQry
Dim rs As New ADODB.Recordset
'Path to the database.
stDB =...