Not Sure if this belongs here or in the VBA section, but ill give it a whirl here.

I am changing the data in a tabel to sort them out, well past what a query can do, i am working this through in VBA.

I am opeing the Results in a
'Dim rstTest As New ADODB.Recordset
'Set rstTest = New ADODB.Recordset
'rstTest .Open "SELECT tblTest.Test1, rstTest.Test2....... etc

I am going to Edit and sort these into lists of what i want, but i was wondering if it is possible to Open a Table and write the details into it.

And way to say Simply tblNew = rstTest

Without a hefty loop?

Cheers

Ralph

There's no way to get around opening a recordset.

When you've opened the recordset, basing it on a table, and then edit the data in the recordset, the data in the table is automatically updated.

It's not clear to me what you're hoping to save.

Alright well ill find and alternitive thanks for your help...

One last questio, Is there any possible way to just say Table.clear?

Instead of Running a loop through the whole tabel deleting each record?

Thanks Mate

CurrentDb.Execute "Delete * From Table-Name" will do what you want.