Forum Discussion
tristaanogre
13 years agoEsteemed Contributor
Have you considered using a DBTable checkpoint instead?
http://smartbear.com/support/viewarticle/11037/
That way you don't have to write out the results to the Excel file, you can then just use the SQL table queries directly. What I would do is loop through your excel sheet and execute each item and then run one DBTable checkpoint at the end.
Also, considering your usage of the Excel sheet, you might want to consider using DDT.ExcelDriver (http://smartbear.com/support/viewarticle/11915/) as the way to loop through your file. This doesn't require you to do any Project variable work.
http://smartbear.com/support/viewarticle/11037/
That way you don't have to write out the results to the Excel file, you can then just use the SQL table queries directly. What I would do is loop through your excel sheet and execute each item and then run one DBTable checkpoint at the end.
Also, considering your usage of the Excel sheet, you might want to consider using DDT.ExcelDriver (http://smartbear.com/support/viewarticle/11915/) as the way to loop through your file. This doesn't require you to do any Project variable work.
Related Content
Recent Discussions
- 3 days agoMW_Didata