store in array and store value in acces table

[luca90]

I loop "line by line" in a text file and get 5 value for each line.

For all 5 value i store in a 5 variable, similar:
value1 in variable1, value2 in variable2, .... ecc

During the loop i want to append all variable in to an array until the code have read entire text file. Now, i want to save entire value of array, "in one shot only" into an access table based this mode:

Array value 1 into rs(0), array value 2 into rs(1), value 5 in rs(4) ecc...

Note:
I use the tipical Ado Jet connection to Access Table

[akhileshbc]

Array value 1 into rs(0), array value 2 into rs(1), value 5 in rs(4) ecc...

What does this means? Separate records? or separate fields? or separate recordsets?

[si_the_geek]

Please stop posting in the wrong forum... I have told you repeatedly that questions that involve databases do not belong in the 'VB6' forum - Thread moved to 'Database Development' forum

[luca90]

What does this means? Separate records? or separate fields? or separate recordsets?

separate recordsets....YES

[dee-u]

Why do you even need a recordset? Why not just create an INSERT INTO sql for each record and issue it once you are done with all the records? In sql server we could separate the DMLs using a semi-colon, not sure with Access but you can try it, I think it will work, something like:

INSERT INTO Table (Column1,COlumn2) VALUES('value1','Value2');
INSERT INTO Table (Column1,COlumn2) VALUES('value3','Value3');