title: Coded UI Test Excel Connection String Directory Error
body: <p>I'm trying to use excel with my coded-ui test but my connection string is not working. Can you help me on this? I'm kind a nuub on this :)
  Ok, here - > my data directory is C:\ (directly in C drive)
  and my connection string is </p>
  
  <p><code>[DataSource("System.Data.Odbc", "Dsn=Excel Files;Driver={Microsoft Excel Driver (*.xls)};dbq=C:\\Data1.xls;defaultdir=.;driverid=790;maxbuffersize=2048;pagetimeout=5;readonly=true", "Sheet1$", DataAccessMethod.Sequential), TestMethod]</code></p>
  
  <p>This works perfectly. But i want my files to be in "D:\TestProjects\Coded2\DataFiles\Data1.xls" and i couldn't do it. getting some errors and test-failing. </p>
  
  <p>How should i write my data directory?</p>
  
  <p>Thank you for your help. </p>