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

How to insert datas from one table to another using ADO connection

P: 2

I am using windows XP

I need a small programme in Visual basic 6 with Access 2000

I have two tables for example one table named student other table named section

In student table rno is primary key. In section table Rollno is primary key

Both tables have datas, I want to insert datas(multiple rows) from student to section.

The coditions is unique datas only (ie. some datas already in section while inserting
datas from student to section the existing datas should be eliminated they wont be inserted)
( by comparin rno with rollno)( i avoid duplicate appending)

Please me code for inserting tables using ADODB recordset

A.Senthil kumar
Sep 10 '08 #1
Share this question for a faster answer!
Share on Google+

Post your reply

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