By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,462 Members | 2,360 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,462 IT Pros & Developers. It's quick & easy.

how to write insert statement without looping for recordset from ado

P: 3
Hi,
I would like to take a recordset and insert its entire contents into a table without looping. I know it can be done using SQL in VBA to achieve this.
Thanks
Kumar
Dec 10 '13 #1
Share this Question
Share on Google+
3 Replies


zmbd
Expert Mod 5K+
P: 5,285
Yes, it's called an insert query and no you haven't given us enough information; thus, a link to general instructions:
Microsoft: Getting started with Access 2010
--->
Microsoft: Introduction to queries Access 2010

best of luck.
-z
Dec 10 '13 #2

P: 3
Hi again,
What I meant to say is doing something like this:
insert into tableA select rs.* from rs... Normally I would do this: while not rs.eof
process
rs.movenext
wend
Thanks
Dec 11 '13 #3

zmbd
Expert Mod 5K+
P: 5,285
yes, same answer, read the link to the queries, it tells you how to use a SQL recordset to insert or append the recordset to a new or current table.
Dec 11 '13 #4

Post your reply

Sign in to post your reply or Sign up for a free account.