Import pipe-delimited text data that contains multi-line fields
I have a pipe-delimited text file that has multi-line fields.
I need to import this file to MS Access or Excel (this was exported out from Oracle).
The desired results are :
However, there's a line space ('cr lf') after every line, and when I import it to Excel, they get separated to different lines even though they should all be in one cell if they are between pipes.
How can I import this to Excel as 3 column, multi-line?