Question Locked

Unable to Copy large Text Files for pasting the data in Excel 2007

0 helpful
14 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

14 replies

by rob miners

increasing your PageFile size.

Go to Control Panel, System Properties and take note of the amount of RAM. Now you need to make sure that the Pagefile is equal to 1.5 times the installed RAM.

Go to Control Panel, System Properties, click on Settings under Performance, click on the Advanced tab, click on Change under Virtual Memory.
Set it to 1.5 Gb

by rajput.vishalsingh

I've tried this & now Total Page File Size on all drives 3292 MB.

But Still not able to copy Text from Notepad to Excel 2007.

by rob miners

By rule of thumb windows likes to have @ least 17% free space on all drives for it to function properly. If you are below this limit, try removing some of the files.

Try deleting all the temp files on the system.

http://personal-computer-tutor.com/deletingtempfiles.htm

Free RAM Optimizer XP will automatically attempt to free a specified amount of RAM, making it available to other applications.

http://www.snapfiles.com/get/foptimizer.html

by chris910

I am not certain of the current limitations but here is an excerpt from the Windows 2000 Resource Kit, Error Messages Reference

The filename file is too large for Notepad. Use another editor to edit the file.

Explanation:
You attempted to open in Notepad a file that is larger than one megabyte.

User Action:
To open this file, you will need to use a text editor that is capable of displaying a file of this size.

by rajput.vishalsingh

I tried all the Possible ways & suggestions but still facing the problem.

I'm Required to open approx 10 - 10.5 MB size Text file which contains rows in range of 50000 to 76000, to be pasted in Excel for further processing.

In the month of March 2008 I was able to paste 75390 rows from Text to Excel.

Pls suggest.

by rajput.vishalsingh

Now available memory is 20%, 26%, 18% & 19% on drive C: to F: respectively, also installed the Free RAM Optimizer.

But still unable to Copy Large Text Files to Excel 2007.

by rob miners

Chris910's advice and try another Notepad. I havent tried this one yet but I will be going to. If you dont find anything here try a Google. Let us know how you get on.

http://www.freedownloadscenter.com/Utilities/Text_Editors_A-G/EditPad_Lite.html

http://www.freedownloadscenter.com/Search/notepad.html

< just out of curiosity how big are these files >
I have no problems opening a 5Mb text file and saving it into Word and 62,768 cells into Excel from Notepad.

Also have a look here.

Troubleshooting Microsoft Excel 2007
http://support.microsoft.com/kb/919196

http://www.officearticles.com/excel/troubleshooting_microsoft_excel.htm

by rajput.vishalsingh

I tried all the Possible ways & suggestions but still facing the problem.

I'm Required to open approx 10 - 10.5 MB size Text file which contains rows in range of 50000 to 76000, to be pasted in Excel for further processing.

In the month of March 2008 I was able to paste 75390 rows from Text to Excel.

Pls suggest.

by rajput.vishalsingh

Tried all of these, but still not able to paste the data.
I'm able to open TXT file of 10 MB Approx but not able to copy from Notepad or other Free Text editor software to Excel 2007.

by Former member

The Text File Importer can quickly and easily import text files (CSV TXT PRN ASCII ....) containing over one million rows of data into Microsoft Excel. And, Excel's Import Wizard does not pop-up with the file is imported!
The Text File Importer is entirely menu driven.
Download here:
http://www.add-ins.com/text_file_importer.htm

Please post back if you have any more problems or questions.

by rob miners

is the exact error message that you are getting when it fails to copy.

This discussion is closed to new replies.