I have successfully made a recordset object full of data from a parameterized SQL Server stored procedure.
Now I would like to quickly zap the resulting recordset object into an Access Table so I can use it as the source for an append query.
I would like to avoid looping through the recordset and appending it row by row, but if I must, I must.
I have noted that a recordset can be persisted to an XML file, but there seems to be no way to "attach" a table to that persisted recordset.
Do you have any other clever thoughts?
Take care,
--Shaun Merrill
Seattle, WA
Now I would like to quickly zap the resulting recordset object into an Access Table so I can use it as the source for an append query.
I would like to avoid looping through the recordset and appending it row by row, but if I must, I must.
I have noted that a recordset can be persisted to an XML file, but there seems to be no way to "attach" a table to that persisted recordset.
Do you have any other clever thoughts?
Take care,
--Shaun Merrill
Seattle, WA