View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default how do I download a csv file with 100,000 records into excel?

Hi

I suggest you try 'cutting it in half' using Wordpad. Mind you, you still
won;t be able to see it all in Excel: you'll have to deal with it in two
bits.

Andy.

"Lauren" wrote in message
...
I have a csv file with 100,000 records on it, I know excel only downloads
up
to a little over 65,000, and I have tried the Wizard, but it won't let me
export specific rows after about 32,000. I have also tried to change the
csv
file to a Word file and cut it into two seperate files, but then Excel
won't
recognise the format. There must be a way!
PS I don't have Access