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
|