PowerPivot cannot import data type ()

[vumian]

Dear all,

I have a excel file, i do import that as external database, but i found that the Field contain data like : 8000007880( )(15)(1), cannot go in table ?
I dont understand why. Please help me to give the solution . Thank you

vumian

 

[Matt Allington]

I guess it is getting confused on the data format. Try using Power Query to load the data, and make sure you format it as text before loading to Power Pivot

 

[scottsen]

Probably early rows had more "int" looking stuff, and it inferred int type. Even without Power Query, I suspect you can just flip the column type to Text, and you will be fine.