Opening Lahman in Excel

Operation Shutdown · 01-13-2004, 09:19 AM

I figured I'd post this here and hopefully find someone who has modified Lahman often enough that they might know this. I'm having trouble opening some of the Lahman database sheets in Excel, specifically, the batting and fielding sheets are not opening completely, and Excel is giving me an error saying that the file is not loading completely. I'm assuming this has something to do with some sort of internal maximum memory thing that Excel limits itself. Is there any way I can get Excel to open the whole file? It opens until 1988, and I want to add the 2003 stats to some of the players.

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.

Operation Shutdown · 01-13-2004, 07:34 PM

Yep that makes sense, though I just did the edits I needed to do in notepad. It was a lot more complicated that way, cause I like to add a header row in Excel and then delete it when I'm done, but wasn't able to in Notepad. Instead, I just sat there with the readme file printed out and sitting in front of me. I'll keep that in mind next time though. Thanks.

01-13-2004, 09:19 AM	#1
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	Opening Lahman in Excel I figured I'd post this here and hopefully find someone who has modified Lahman often enough that they might know this. I'm having trouble opening some of the Lahman database sheets in Excel, specifically, the batting and fielding sheets are not opening completely, and Excel is giving me an error saying that the file is not loading completely. I'm assuming this has something to do with some sort of internal maximum memory thing that Excel limits itself. Is there any way I can get Excel to open the whole file? It opens until 1988, and I want to add the 2003 stats to some of the players. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

01-13-2004, 07:34 PM	#3
Operation Shutdown All Star Reserve Join Date: Jun 2002 Location: Pittsburgh PA Posts: 912	Yep that makes sense, though I just did the edits I needed to do in notepad. It was a lot more complicated that way, cause I like to add a header row in Excel and then delete it when I'm done, but wasn't able to in Notepad. Instead, I just sat there with the readme file printed out and sitting in front of me. I'll keep that in mind next time though. Thanks. __________________ "And Shepherds we shall be, For thee, my Lord, for thee. Power hath descended forth from Thy hand, Our feet may swiftly carry out Thy commands. So we shall flow a river forth to Thee, And teeming with souls shall it ever be. In Nomeni Patri Et Fili Spiritus Sancti."

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.