Hello all,

I write in VB6 using Access2000 as my database.

I want to write a small utility to append data records from one table (in one database) to another table (in another database). Apparently the two tables have almost same field names. How do I go about it. I mean one or two line commands that will do the appending.

Thanks

-Tallon

You can do it using a single SQL statement, you just need to fully qualify your table names:

     This will insert all the rows from the table in FileName2 into the table in FileName1.


Regards
Owain Williams

From db1 create the following query

INSERT INTO Table1 ( Field2, Field3, Field4, Field5 )
SELECT Table1.Field2, Table1.Field3, Table1.Field4, Table1.Field5
FROM Table1 IN 'E:\db2.mdb';


this gets values from db2/table1 and inserts them into db1/Table1. You can create a query programatically as well. You may be able to pass this string on a command object.






Sal

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

imagetvr, it is extremely bad form to hijack someone else's posting.

To all: This question is at http://p2p.wrox.com/topic.asp?TOPIC_ID=73935

Please answer imagetvr there, instead of here