excel与mysql的区别,比较excel和Sql数据库

Hi,

Can any one help me to find solution for this.I googled and I have not found related answers.

In coded UI test,I have an Excel Sheet with certain Testcase_Id and related method names in it.

And simultaneously I have an SQL Database where I have all the testcases and values for the fields.

My work is I have to compare the testcase Id from the Excel sheet to the SQL database. when the testcase Id''s are same the test has to be run for the particular method and particular testcase alone.

I am a beginner so please help me.

Regards,

Revathi

解决方案The simplest way to do it is to export your data from SQL to an excel file and create a file with test cases from both SQL and the original excel file. Now, use excel functions / macros to filter and remove rows with duplicate testcase ids.

This[^] link should be helpful for the duplicate removal.