Excel doewn't have enough rows to import a text file with 700,000 records.
Is there a way to detect this with say a macro, open the file with the open
wizard (to parse the .txt into cells), put 50,000 parsed records in the first
tab. open up another tab and name it, put the next 50,000 parsed records in
the tab and name it, etc. until enough tabs are opened, named, and parsed to
hold 700,000 records? Or am I asking for the sky?
thanks,
david