Populating a RecodSet from an Array

[Manuel Cavero]

Good morning/afternoon everyone:

I'm trying to update a table in a Excel's workbook using ADO. Few things before the code:

1. I have to say that I checked the property RecordSet.Status for the AddNew method and the boolean given it is true.
2. I'm using a Microsoft.ACE.OLEDB.12.0 driver.
3. The data is in a variant array callled Temp. This array has 6 columns -the same quantity as names has- and 200 rows.

Let's have a look into the code:

Sub TEST(Temp() as Variant)
Dim Connection as String
Dim Names as Variant
Dim Query as String
Dim RS as New.ADODB.RecordSet
Names = Array("FE", "HO", "AP", "MAX", "MIN", "CIE")

'Open the recordset in a read/write mode
RS.Open Query, Connection, adOpenDynamic, adLockOptimistic
RS.MoveLast
RS.AddNew Names, Temp 'Here I tried to populate the recordset from the array values 
RS.Update
RS.Close

I'm using this method because I think is quicker and simpler, but I got an error on line RS.AddNew, any ideas/suggestions, etc...?

Many thanks to you all