title: SQL Query Run Against Excel Workbook Returns Truncated Text Field
body: <p>I'm running a SQL SELECT query through an ADO connection to an Excel 2007 workbook with the following code (using a custom version of VBScript)</p>
  
  <pre><code>dim ado, rs
  set ado = CreateObject("ADODB.Connection")
  ado.ConnectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=workbook.xlsx;Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1"";"
  ado.open()
  set rs = ado.execute("SELECT * FROM [sheet1$]")
  </code></pre>
  
  <p>which is straighforward. The problem is that any cell that has text longer than 255 characters is truncated; is there any way around this? Is there a property in the connection string that will support this or is it an option I need to change in the excel document itself? I have tried MSSQL's CAST() function but this just causes an error when executed.</p>
  
  <p>Any help would be greatly appreciated.</p>