I've been evaluation Robot for a couple of days and need help with something. I want to take two tables from 2 seperate MS Access 2003 Database (say tableA from dbA and tableB from dbB) and compare the data in their fields. Suppose they have the exact same column fields.
HOw can I do this thru Robot? I just need the simplest solution. Please help.
Look at the Yahoo site, some code from Maxine McNaughton (DataServices2), a really good function to call from multiple data sources. I was able to implement it into our project which queries agaist three Oracle databases. It also resolves the unsupported data types that are such a pain in the back side in Robot. Don't forget to register the DLL.