title: Source data type "200" not found error when exporting query results to excel Microsoft SQL Server 2012
body: <p>I am very new to Microsoft SQL Server and am using 2012 Management Studio. I get the error above when I try to export query results to an excel file using the wizard. I have seen solutions posted elsewhere for this error but do not know enough to figure out how to implement the solutions recommended. Can somebody please walk me through one of these solutions step by step?</p>
  
  <p>I believe my problem is that the SQL Server Import and Export Wizard Does Not Recognise Varchar and NVarchar which I believe is the data type for the columns that I am receiving errors for. </p>
  
  <p><a href="https://stackoverflow.com/questions/14823628/source-type-200-in-sql-server-import-and-export-wizard">Source Type 200 in SQL Server Import and Export Wizard?</a></p>
  
  <p><a href="http://connect.microsoft.com/SQLServer/feedback/details/775897/sql-server-import-and-export-wizard-does-not-recognise-varchar-and-nvarchar#" rel="nofollow noreferrer">http://connect.microsoft.com/SQLServer/feedback/details/775897/sql-server-import-and-export-wizard-does-not-recognise-varchar-and-nvarchar#</a></p>
  
  <p>Query:</p>
  
  <pre><code>SELECT     licenseEntitlement.entID, licenseEntitlement.entStartDate, entEndDate, quote.quoteId, quote.accountId, quote.clientId, quote.clientName, quote.contactName, 
                        quote.contactEmail, quote.extReference, quote.purchaseOrderNumber, quote.linkedTicket
  FROM         licenseEntitlement INNER JOIN
                        quote ON quote.quoteId = SUBSTRING(licenseEntitlement.entComments, 12, PATINDEX('% Created%', licenseEntitlement.entComments) - 12)
  inner join sophos521.dbo.computersanddeletedcomputers on computersanddeletedcomputers.name = entid and IsNumeric(computersanddeletedcomputers.name) = 1
  WHERE     (licenseEntitlement.entType = 'AVS') AND (licenseEntitlement.entComments LIKE 'OV Order + %') and entenddate &lt; '4/1/2014' 
  ORDER BY licenseEntitlement.entEndDate
  </code></pre>
  
  <p>Error:</p>
  
  <pre><code>TITLE: SQL Server Import and Export Wizard
  ------------------------------
  
  Column information for the source and the destination data could not be retrieved, or the data types of source columns were not mapped correctly to those available on the destination provider.
  
  
  [Query] -&gt; `Query`:
  
            - Column "accountId": Source data type "200" was not found in the data type mapping file.
            - Column "clientId": Source data type "200" was not found in the data type mapping file.
            - Column "clientName": Source data type "200" was not found in the data type mapping file.
            - Column "contactName": Source data type "200" was not found in the data type mapping file.
            - Column "contactEmail": Source data type "200" was not found in the data type mapping file.
            - Column "extReference": Source data type "200" was not found in the data type mapping file.
            - Column "purchaseOrderNumber": Source data type "200" was not found in the data type mapping file.
            - Column "linkedTicket": Source data type "200" was not found in the data type mapping file.
  </code></pre>
  
  <p>If any more details are needed please let me know</p>