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

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

Pete,
I am using office 2003.

Sujesh
--
Sujesh R. Nair


"Pete" wrote:

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

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

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.

--
Sujesh R. Nair


"Pete" wrote:

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

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

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.



Sujesh wrote:

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

--

Dave Peterson