Iam using VB6 and DataBAse access XP, iam using ado to connect to the database. i want to add a number of records from one table to another. now iam using
Select * Into NewTable From OldTable
this method create the table then added the new records to it . that is fine but the problem that i want to add another number of records from the same table to the same new table without loosing the newtable records , is this possible?