Update database based on data in ListObject

[Stevenn]

How can I create a SQL query based on the column names and values in each row? I've tried to search for a simple and free Excel based database management system, but couldn't find anything.

I want to perform the action which i've tried to describe in codes below. For each row in a ListObject I want to perform a SQL query with the data in each column based on an ID.

Dim objRow As ListRow

For Each objRow in Worksheets(strWorksheetName).ListObjects(strDataListName).ListRows
    strSQL = "UPDATE table SET column_name_i = column_value_i WHERE column_name_1 = column_value_1" ', for i > 1
Next

 

[Stevenn]

I guess I should use a two-dimensional arrays such as the code below, but I don't know how to handle two-dimensional arrays in VBA.

For Each objRow In objList.ListRows
    For Each objColumn In objList.ListColumns
        strColumns(objRow.Index)(objColumn.Index) = objRow.Range.Value
    Next
Next