How do I populate a table with an ADOX recordset?

[jonomac]

I've been stumped with this for ages and keep having to go back to DAO to get around it...

I have created a recordset using ADOX, but then how do i put the results into a table that already exists or even just add it to a new one?

Its been driving me nuts... I've tried adding a new table to the catalog etc and appending columns but then how do i transfer the data across?

Thank u for any help!