Service Virtualization

I have created a database table using MYSQL with columns equal to the columns present in the excel file. I need to read the excel file and copy the values from excel file to the database table. Is there any direct option available in devtest to achieve this?

Have you tried using the SQL Database Execution (JDBC) step?

SQL Database Execution (JDBC) - DevTest Solutions - 10.1 - CA Technologies Documentation 

Option 1

1. Read dataset and use jdbc step to insert the data.

2. Run it in loop.

Option 2 (requires tdm jars that reads excel worksheet as table)

1. read all rows using sql and write to table.

You can use Read rows from Excel dataset couples with SQL execution Step, in a loop until the sheet is exhausted and all rows inserted into table...see screens below

Thanks for the swift response!

This steps are working fine, but in the SQL Database Execution step I am not able to execute the INSERT statement.

I am getting the following exception "java.sql.SQLException: Can not issue data manipulation statements with executeQuery()" 

Do I need to add any additional jars to execute the INSERT statement?

Uncheck the box- return result as recordset.