[RESOLVED] creating new table ////Urgent///

[nagasrikanth]

hi..

I wanna to insert a set of rows (only set of rows ..not all the tbl)from a table which is located in different db ..into a tbl which is existed in my db..

I had already build a record set...i get the required records into recordset object..but im unable to place them in to the table..
Since there are lot of records and lot of columns ..I can't add 1 by one by using ADD and Update methods...
Is there any other way to achive it..


Please help....

Thanx & regards
Anu..

[Besoup]

hi..

I wanna to insert a set of rows (only set of rows ..not all the tbl)from a table which is located in different db ..into a tbl which is existed in my db..

I had already build a record set...i get the required records into recordset object..but im unable to place them in to the table..
Since there are lot of records and lot of columns ..I can't add 1 by one by using ADD and Update methods...
Is there any other way to achive it..


Please help....

Thanx & regards
Anu..

Assuming you are using Access, you could probably just make an append query in one of the databases to do the job.