SAP Knowledge Base Article - Preview

1408404 - Excel varchar data type converting to numerics only


I am creating a dataflow that uses an excel workbook as a source and the first column in the workbook is defined as a varchar(30). This column is defined as varchar(30) in subsequent query and template table. When the first value in column are numeric only numeric values are read from Excel, alpha-numeric values are nullified. If the first value in column is alpha-numeric then column is properly read as varchar.



  • Data Services (DS)
  • Windows 2003
  • Excell 2003
  • SQL Server 2005


SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2


bods , KBA , EIM-DS , Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.