visualbasic
asked on
Append using Ado
Hello
I need to append the contents of a table "Temp" in a borland db to a table "Temp" in an access database using ADO
The source Database will be assigned from a file so I am only specifying Borland for this Question.The source could be any database .If answered could you show the code from connecting to closing.
Regards T
I need to append the contents of a table "Temp" in a borland db to a table "Temp" in an access database using ADO
The source Database will be assigned from a file so I am only specifying Borland for this Question.The source could be any database .If answered could you show the code from connecting to closing.
Regards T
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I don't think that there is as the two recordsets are on different connections. The only way you could do that would be to add the non-access temp table as a linked odbc table in the access database then you probably could do an INSERT INTO ACCESSTEMP SELECT * FROM NON-ACCESSTEMP type SQL statement.
ASKER
Thanks Tim
I was wondering was there an sql which could do the same function using ADO??
Cheers T
I was wondering was there an sql which could do the same function using ADO??
Cheers T
ASKER
I was wondering was there an sql which could do the same function using ADO??
Cheers T