title: Data type issue creating an Excel file using the ACE OLEDB Provider
body: <p>I'm using the ACE OLE DB provider and an Execute SQL Task in order to create an Excel file.
  The connection string I'm using is like this one:</p>
  
  <pre><code>Data Source=C:\MyFolder\MyFile.xlsx;Provider=Microsoft.ACE.OLEDB.12.0;Extended Properties="EXCEL 12.0 XML;HDR=YES";
  </code></pre>
  
  <p>and the SQL command is this one:</p>
  
  <pre><code>CREATE TABLE [Query] (
  [ProductAssemblyID] Numeric,
  [ComponentID] Numeric,
  [ComponentDesc] String,
  [TotalQuantity] Numeric,
  [StandardCost] Currency,
  [ListPrice] Currency,
  [BOMLevel] Numeric,
  [RecursionLevel] Numeric)
  </code></pre>
  
  <p>Then I'm using an Excel Destination to populate the file. When I open the resultin file, all columns are Text columns and numbers are stored as text.
  Where am I doing wrong?</p>
  
  <p>Thank you.</p>