I have a routine like calulating the State,City,county,Other Taxes. It has some calculation with some other Fields.
Once the Calculation has finished I need to Insert the Records In Mytable Like // AutoNum, AcNo,State,City,County,Other //. In this case
if i insert in forLoop every state,city.... will insert diff rows Like
But I need the Row to Insert All Taxes.
Because of this I am just trying to insert into Array and then inserting.
I would use a programmatically created recordset and not an array. This is a recordset that is not tied to a database but rather fields you create dynamically and can manipulate like a recordset. It also gives you many more options to handle the data since methods already exist.