How to read data from excel using ADO from codeUITest or any test?

Question

Hi
  This is saravana.We are startd to learning vsts2010.
Tried to read data in excel sheet from test(Basic Unit test) or codedUI.Below mentioned code i used but not able to read data.
The problem is one we type "Dim oConn as new ado" then automatically adodb.connection object will be displayed.
I think some import file is required or do we need to select ado reference from option.Can any one help me to solve this issue?

Dim oConn As New ADODB.Connection

oConn.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _

           "Data Source=C:\Book1.xls;" & _

           "Extended Properties=""Excel 8.0;"""

oConn.Close

             

Answer 1

check out http://blogs.msdn.com/mathew_aniyan/archive/2009/03/17/data-driving-coded-ui-tests.aspx for an easyay to ind directly to CSV files

---

http://blogs.msdn.com/anutthara

Answer 2

check out http://blogs.msdn.com/mathew_aniyan/archive/2009/03/17/data-driving-coded-ui-tests.aspx for aneasy way to ind directly to CSV files

---

http://blogs.msdn.com/anutthara

I have checked out it and found so many useful information from it. It is really a great help. Thanks for sharing.