Acess2000: Flushing data from VBA-created recordset to table

[Arvi Laanemets]

Hi

To append data to a table in VBA, I can:
a) Append data to table using append query;
b) Open the table as recordset, add rows and edit fields in those rows;

But is there a way to create a new empty recordset with structure identical
to table, add there new rows and fill them with data using VBA, and finaly
append all those records to table like with append query?

I can't use query, beacause source data are read from 3rd-party program
report, saved as excel workbook - and data there aren't in normal table
layout, so I have to analyze every row in source table separately. I don't
want to open the whole target table as recordset, because the target table
will be probably too big in future, and any existing rows there aren't
edited anyway.

Btw. I think I just found a roundabout solution. I can have a separate
export file - which is cleared of all old entries, opened as recordset,
filled with new data and closed. And after that is an append query used to
add contents of export file to target table. Or is there some better
solution?

Thanks in advance!