Thanks for the suggestions, fellows. Two problems:
1. When I use Data|Import External Data I still get I get one field for
each record with all the infomation, including the commas.
2. Compared to the one click that opens a *.csv file with each comma
delimited field placed in a separate field, ready for a simple copy and
paste, importing external data needs many clicks for a place to save
the file and many clicks in the data import wizard. Then I have a *.csv
on disk that I have to remember to delete.
I suspect there's an add-in I haven't installed or an options
setting I haven't checked. Any ideas?


Earl Kiosterud wrote:
Very true. And depending on your release of Excel, you get different

importing capabilities. For repeated importing of the data, Excel
2002 and
up is good. See www.smokeylake.com/excel for details. Read "Text
files and
Excel."

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

"Jerry W. Lewis" wrote in message
...
Rename is not necessary if instead of opening the .csv file, you
open
Excel and use Data|Import External Data

Jerry

Frank Kabel wrote:

Hi
I'd guess this PC has different regional settings (check:
Start-menu -
Control Panel - Regional settings).
One workaround: Rename the file to *.txt and open it afterwards
with
Excel. Now the textimport wizuard should start and you can define
the
coma as delimiter