请参考下MVP Jon Peltier的解答:
Nothing magic about pipe-delimited format. It's text, with entries separated by a pipe (vertical line character) within a record, and by carriage returns between records. Here's a nice explanation of the process, with some code examples:
http://www.mcgimpsey.com/excel/textfiles.html
There are a few utilities that will save a worksheet as pipe-delimited:
http://www.smokeylake.com/excel/text_write_program.htm
To find things like this, you can use Google. "Excel export pipe delimited".
- Jon
-------
Jon Peltier, Microsoft Excel MVP
|