Forum Discussion
8 Replies
Sort By
- anupamchampatiFrequent Contributoruse batch and export to csv very simple.and easy to use
sqlcmd command lines like connections strings db name and -i input sql file (you can specify the query which output you want to export) - tristaanogreEsteemed Contributor
Not native to TestComplete, no. There are some SQL commands that you can execute to do such, requiring certain drivers to be present on your SQL server. But generally, if you're reading the values in via script and then exporting out also via script, that's the best option you have at the moment.
- Vallalarasu_PFrequent Contributor
- AdagioFrequent Contributor
Thank you Valla, I was actually trying ot find a way to copy all the rows faster. This solution also goes row by row, so it would be significantly slow while copying around 400k rows to an excel.
Appreciate you taking time looking at this.
Thank you
Abhi
- tristaanogreEsteemed Contributor
Let's approach from perhaps a different direction. What's the purpose for the output to XLS? What are you intending to do with it?
Related Content
Recent Discussions
- 3 days agovladd1