Recordset into a new table in one go ?

[chiragrawal]

Hi Guys,

Is there a way that i can put an ADODB.recordset in a new table using VBA in MS access 2013?
The record set is dynamic, hence a new table should get created every time.

Looking forward to your replies, Thanks !


Thanks & Regards,
CR

[ItsMe]

Perhaps you can manage table objects using TableDefs
http://msdn.microsoft.com/en-us/libr...ffice.12).aspx