SAP Knowledge Base Article - Preview

1815924 - Data Services read alphanumeric values from Excel sheet as Null


  • The input Excel sheet has one or more columns with 'general' format.
  • The column contains a few rows with simple numerical values in those columns followed by a few empty rows (read as Null by Data Services) and then an alphanumeric value.
  •  When Data Services reads from the column it also reads the alphanumeric value followed by Nulls as a 'Null' instead of reading the actual value. 
  • The Column Format in Excel is General and the column includes numbers and alphanumeric values



SAP Data Services


SAP Data Services 4.0 ; SAP Data Services 4.1 ; SAP Data Services 4.2 ; SAP Data Services XI 3.0 ; SAP Data Services XI 3.1 ; SAP Data Services XI 3.2


KBA , EIM-DI , Data Integrator, Composer , EIM-DS-EXE , Job Execution , 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.