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?
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.