Hello

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 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

Hi Senthil

It looks like you are outsourcing your assignment to the Wrox team:)

Here are some good examples for you to refer (http://www.timesheetsmts.com/adotutorial.htm)

http://support.microsoft.com/kb/183606


http://www.aspfree.com/c/a/Microsoft...ccess-and-ADO/

http://www.w3schools.com/ado/ado_connect.asp

Also if I can ask, please ensure that you write a collection of data or multiple data as 'data' and not 'datas'

Cheers
Shasur




http://www.dotnetdud.blogspot.com

VBA Tips & Tricks (http://www.vbadud.blogspot.com)

Thanks for reply

I am beginner to VB. I am developing small projects to learn visual basic 6. I wish to transfer multiple rows from one table to another table in same database my condition is " I don't insert duplicate entries" . IF same "rono" appears in second table that row should be ignored. I am outsourcing my work. I wish to learn some advance database concepts.

Thanks
senthil