Avatar of JamesNT

asked on 

Flush ADODB.Record into Access Table

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

Open in new window

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?

Microsoft AccessVBA

Avatar of undefined
Last Comment

8/22/2022 - Mon