Thank you Dave for replying.

I get the file from an NT box and not sure how lines end. Is there a way to
find out?
Do you know why Excel returns the error message "File not loaded completely"?
The delimiter is comma, which is standard

Regards

"Dave Peterson" wrote:

Two questions:

#1. Does each line of your CSV file end with a carriage return/line feed?
(If I get a file FTPed from a UNIX box, I have to add those linefeeds.)

#2. Does the delimiter in your CSV file match the character under:
Windows start button|settings|control panel|regional settings applet|
Number Tab|list character?



hbarniv wrote:

I use Excel XP and when try to open a .csv file, get a message:"File not
loaded completely". I click OK and get one long row of data. Anyone knows
why?

ALso, when importing the .csv file to Excel, the columns get shifted and in
one field I get | instead of comma. Any ideas?

Thanks

--

Dave Peterson