Pipe Delimited Import to Power Pivot

    General discussion

  • I am trying to import a pipe delimited (|) text file into the Power Pivot window.  In the preview screen, everything looks good and it appears that the data is being parsed out into the correct columns.  But then when I finish the import, much of the data simply disappears and does not get imported.  I can import this same file into a standard Excel spreadsheet with no problems and I can import this same file into Access with no problems.  I can certainly find another way of getting the data into Power Pivot; but it would be much more convenient if I could import the file as it currently sits.  Any ideas on how to rectify this?
    Wednesday, July 03, 2013 2:02 PM

All replies