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

Expand Post »

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)

Please me code for inserting tables using ADODB recordset

A.Senthil kumar

imagetvr

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

5 posts
since Aug 2008

Permalink

Sep 11th, 2008

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

if rno and Rollno are same then try this query

INSERT INTO Section(FirstName, LastName)
SELECT FirstName, LastName FROM Student where student.rno=section.rollno

i hope it will work

Last edited by guest11; Sep 11th, 2008 at 9:13 am.

guest11

Reputation Points: 10

Solved Threads: 2

Junior Poster in Training

Offline

59 posts
since Nov 2007

Permalink

Sep 11th, 2008

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

You can do this in a number of way, one simple way is that,

1. if you want to insert only student whose info is in students table but not in Section table,
then select uisng this SQL

SQL= "SELECT * FROM Student WHERE rno NOT IN(SELECT DISTINCT Rollno FROM section WHERE Student.rno= section.Rollno)ORDER BY rno"

The Above SQL will select only those student which are not in the Section table so that you can insert all the elected list to the Section Table by using AddNew command.

Try this, its so simple. There a number of way for this.

K.Vanlalliana

Reputation Points: 10

Solved Threads: 4

Light Poster

Offline

44 posts
since Jul 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Date Picker Problem

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Generating words in random letters in a 5x5 dimension textboxes

DaniWeb Message

Cancel Changes

User Name
Password