none
Number formats changing upon import from a CSV file

    Question

  • Hello,

    I am having an issue when I import a CSV file into Powerpivot. A particular value in the CSV file is decimal and upon import it is changed to  a whole number.

    When I open a portion of the file into excel to ensure that the field is truly formated as decimal , it works fine.

    How can I prevent this from happening?

    Thank you,

    Mark Salvato

    Thursday, May 02, 2013 7:31 PM

Answers

  • Mark, what you likely need is a schema.ini file. You create it in notepad, it resides in the same directory as the csv file and contains details of colums and the desired format? PowerPivot uses these instructions on import. http://msdn.microsoft.com/en-us/library/ms709353(VS.85).aspx

    Jacob | Please mark helpful posts and answers


    Thursday, May 02, 2013 8:39 PM