Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server > SQL Server Forums > SQL Server PowerPivot for Excel > Invalid import of data

Answered Invalid import of data

    •  
      Wednesday, January 04, 2012 8:24 AM
       
       
      Sign In to Vote
      1
      Sign In to Vote

      I have a column consisting of text strings; if some of these strings consist of only digits, PowerPivots treats the whole column as number column, and skips all rows that can't be converted to a number.

      Changing column type to "Text" doesn't help.

      Ideas?

       

    Answers

    • Monday, January 16, 2012 6:47 AM
       
       Answered
      Sign In to Vote
      0
      Sign In to Vote
      It seems this problem is fixed, when I append a leading space to every "all-number" field
      • Marked As Answer by user4756 Monday, January 16, 2012 6:47 AM
      •  
       

    All Replies