Link to home
Start Free TrialLog in
Avatar of visualbasic
visualbasicFlag for Ireland

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
ASKER CERTIFIED SOLUTION
Avatar of TimCottee
TimCottee
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of visualbasic

ASKER

Thanks Tim
        I was wondering was there an sql which could do the same function using ADO??
Cheers T
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.

Thanks Tim
        I was wondering was there an sql which could do the same function using ADO??
Cheers T