I have an ADODB.Recordset in Access VBA that I need flushed out to a table in Access.
Dim RowSet as ADODB.Recordset
comm.CommandText = "[qryA042 new claims payors - Need Groups]"
comm.CommandType = adCmdTable
Set RowSet = comm.Execute
The data is coming from a SQL Server view hence why using ADODB. So how do I get that into a table in the current Access database?