Compare Excel-Data with data from a DBTable

Hi,



i am new with Testcomplete and need support for this topic.





My Testproject so far:



1. prepared data in a excel-file

2. created a Keywordtest with a Data-Driven Loop , where i process the data from the excel-file





Target:  



I want to compare a column value (excel) which i use in the data loop with column values of a database_table in the background.

In TC you can create DBTable Objects.



Which is the best way to compare data for these topic ?



It is possible in TC, when i create a SQLStatement (DBTable-Object)

to have direct access to a column value from the excel-file, for a more specific query ?





It would be nice, if somebody have a solution for me (Links,Articles,Posts,Guides...)



      

Ralf