How to add data from one TS database to another?

[Rafi2003]

HI,

This is really a simple and basic question.

I'm collecting data in one local database (Access/Jet). I have the same database somewhere else and I would like to transfer the data I have collected locally to that other one.

Is there a tool within the TS environment to help me do that or do I need to use MS Access in order to do it?

Is it possible to do it programmatically?

Thanks
Rafi

[Dennis_Knutson]

You have all of the database steps to work with. You can open one, do a SQL query in which you SELECT the data save it to TestStand variables and then open the second db and do a SQL INSERT to that. Tools for database synchronization are probably built into Access and that might be the more efficient method though. The TestStand ActiveX adapter can be used or maybe you can write a stored procedure that will do it for you.