OOTP Developments Forums - View Single Post

Nukester · 01-13-2004, 11:55 AM

Unfortunately in this case, Excel will only open slightly more than 16,000 records. One thing you can do is to make a copy of the files (just incase), then open in Notepad. Cut a portion of the file out of there and paste into a new file (effectivley splitting the data into 2 smaller pieces).

Open in Excel and add in your data. Save as a .csv file, and open that back up in Notepad, and past it back into the file with the other data (combine the 2 tables back together).

I think this makes sense.

01-13-2004, 11:55 AM	#2
Nukester All Star Starter Join Date: Dec 2001 Location: Newburgh, NY Posts: 1,923	Unfortunately in this case, Excel will only open slightly more than 16,000 records. One thing you can do is to make a copy of the files (just incase), then open in Notepad. Cut a portion of the file out of there and paste into a new file (effectivley splitting the data into 2 smaller pieces). Open in Excel and add in your data. Save as a .csv file, and open that back up in Notepad, and past it back into the file with the other data (combine the 2 tables back together). I think this makes sense.