Hi there,

It's been quite a while I've used Access and have foregotten certain things. Anyway, I get the data from external DBase into the RecordSet and would like to put that into a Access table. In Excel it will be e.g. Cells(2, 1).CopyFromRecordset dataSet. How to do this in Access?

Another question would be how to clear all from the table before populating this table?

Thank you in advance.