the <b>insert into</b> works fine when the source is <u>from</u> another table but i'm trying to dump an ado recordset(disconnected) into a table in msaccess.
does anyone know how to copy adodb.recordset in memory to a table in msaccess?
in a way similar to dumping one to a spreadsheet like - range.copyfromrecordset(rs)
can one of you guys show me the actual working code that does this?
and can it be done with something like "exec [qry] p1, p2 ..." (to the main query that selects from a query with parameters? i can't get it to work
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.