title: Excel Arabic Column Query .Net
body: <p>I have Excel Sheet with Arabic text in the columns, When I want to retrieve data in vb.net always facing a problem :</p>
  <blockquote>
  <p>No Value Given for one or more required parameter</p>
  </blockquote>
  <p>Code Is This:</p>
  <pre><code>Dim Dta1 As OleDbCommand
  Dim Dta1 As OleDbCommand
  Using conn As New OleDbConnection(&quot;Provider=Microsoft.ACE.OLEDB.12.0;Data Source=&quot; + Excel + &quot;;Extended Properties=Excel 12.0;&quot;)
      conn.Open()
      Dta2 = New OleDbCommand(&quot;Select  Count([إسم الثلاثي للمريض]) From [Sheet1$A:S] GROUP BY  Name HAVING COUNT(*) &gt; 1&quot;, conn)
      Dta3 = New OleDbCommand(&quot;Select  Count([رقم الهاتف]) From [Sheet1$] GROUP BY  Phone  HAVING COUNT(*) &gt; 1&quot;, conn)
      Dim b As Integer = Dta2.ExecuteScalar
      Dim c As Integer = Dta3.ExecuteScalar
  End Using
  </code></pre>
  <p>The code stops at Dta2.ExecuteScalar</p>