> OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools

munstermash · 02-17-2009, 01:02 PM

Has anyone came up with an easy way to get the CSV dumps into an excel database?

Comedian2004 · 03-12-2009, 10:36 PM

Just load them in. Follow the wizard to set up the fields.

NOTE: Excel pre-2007 cannot handle more than 65,536 rows, so you can't load the huge files in.

You are actually better off loading the csv files into Access as you can create lookup tables, and sort data easier, if you know Access.

02-17-2009, 01:02 PM	#1 (permalink)
munstermash Minors (Single A) Join Date: May 2002 Posts: 79	CSV Dumps Into Access Has anyone came up with an easy way to get the CSV dumps into an excel database?

03-12-2009, 10:36 PM	#2 (permalink)
Comedian2004 Hall Of Famer Join Date: Nov 2004 Location: In a house in Saint Cloud, Florida. Posts: 6,751	Just load them in. Follow the wizard to set up the fields. NOTE: Excel pre-2007 cannot handle more than 65,536 rows, so you can't load the huge files in. You are actually better off loading the csv files into Access as you can create lookup tables, and sort data easier, if you know Access. __________________ Visit www.planetootp.com for my MODS. Like BLUES? Visit www.smokestacklightnin.com, you will LOVE it! New show every Monday!! New Blues HOF!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

> OUT OF THE PARK BASEBALL 9 > OOTP 9 - Mods > Database Tools

CSV Dumps Into Access