Hi There!
I’m unable to copy large Text Files for pasting the data in Excel 2007.
I’m required to handle large amount of data & get the data from Text files.
I’m not able to copy data more than 30000 rows from Notepad to Excel 2007.
But if I open the Txt file in Excel & then copy paste the same data I’m able to do the Same!
I’m using Windows XP Prof. with 1GB RAM, 4 partioned Hard Disk of 18.6 GB each with Total Free Space of 15.24 GB(3.44 GB, 3.21 GB, 4.15 GB, 4.44 GB on respecting drives C: to F:), Virtual Memory 1674 MB Total, 1054 MB Free,
PageFile Size – 756 MB, In use -100 MB, Max used-118 MB.
Pls guide me how to resolve this issue! As I was able to copy paste upto 70000+ rows from Notepad to Excel 2007.
