Strange Problem...

S

Sujesh

Hi!!!
I am faced with a strange problem. A program generates incremental numbers
and writes to a .csv file. If there are more than 60,000 records, it writes
60,000 records into one file and the remaining records into another file. i.e
it makes each file of 60,000 records or less. One file that I have has about
16460 records. When I open the file in Excel, it shows the count as 16322,
but when I open it in a text editor like Wordpad or Textpad, it shows me the
correct number as 16460 records.

Why does Excel behave like this? Siince I cannot attach files here, if
needed, I can mail the files for your review.

Pls help.

Sujesh R. Nair
 
P

Pete

I think Excel 95 had a limit of 16k rows - what version are you using?

Another approach to get round this problem is to rename the .csv file
to .txt and then use the Data Import Wizard to import it - see if this
allows you to import all 16460 records.

Pete
 
P

Pete

Ok, well you could still try my suggestion - it worked for me when I
had a similar problem recently. I didn't find out what was causing the
problem, but it allowed me to import the complete file which is what I
wanted.

Pete
 
S

Sujesh

Thx a lot. It worked. A very strange problem and I thought csv was the
easiest means of data handling. Would love to know why this happens, though!!!

Thx again Pete.
 
P

Pete

I often have to rename csv files to txt - for one thing, you lose
leading zeroes from a csv file, and this is very important when dealing
with phone numbers as I do.

Pete
 
D

Dave Peterson

If you're using xl2003, then you're using a MAC, right?

Maybe it's a difference in the way the MAC/Unix and Windows/DOS treats end of
lines.

In the Windows world, an end of line marker is Carriage Return followed by a
Line Feed (CrLf). In the MAX/Unix world, (I think) it's just a Line Feed.

Maybe your text editor is smart enough to do the conversion from Lf to CRLF.
 
Top