More MS Access fun with the .CSV dump! Career All Star Stats!

silvam14 · 08-23-2006, 10:45 AM

Just a little something I produced in MS access using the csv files.

I realized that the game by game stats tables get truncated and re-populated with each season which is a downer. (It must be to limit size) So, in order to get the career stats. I import the new csv the day after each all star game, and then I have an append query I use to populate two tables which I created (Batting and pitching stats) I then run my report off of those.

Anyway, check it out

Hellion9 · 08-23-2006, 10:49 AM

Quote:

Originally Posted by silvam14

Just a little something I produced in MS access using the csv files.

I realized that the game by game stats tables get truncated and re-populated with each season which is a downer. (It must be to limit size) So, in order to get the career stats. I import the new csv the day after each all star game, and then I have an append query I use to populate two tables which I created (Batting and pitching stats) I then run my report off of those.

Anyway, check it out

Nice - you and Comedian could become the database workaround experts. I need to get round to doing some work on this (like that will ever happen!)

silvam14 · 08-23-2006, 11:02 AM

Quote:

Originally Posted by Hellion9

Nice - you and Comedian could become the database workaround experts. I need to get round to doing some work on this (like that will ever happen!)

If only I had comedian's talent!

Thanks for the compliment though. I am pretty good with access, but have no program writing ability. I could write access queries and post the database so that all anyone would need to do is download the db, and import their tables into it.

It seems like a bulky thing though. Maybe Mr Anderson will be able to come up with a better way.

Hellion9 · 08-23-2006, 11:05 AM

Quote:

Originally Posted by silvam14

If only I had comedian's talent!

Thanks for the compliment though. I am pretty good with access, but have no program writing ability. I could write access queries and post the database so that all anyone would need to do is download the db, and import their tables into it.

It seems like a bulky thing though. Maybe Mr Anderson will be able to come up with a better way.

Well (no offense intended), based on what I've seen him produce, that is almost assured - the guy is killing me with how good his ideas are. ood on him - we should all show such commitment! This is a good idea, though - I like it!

Raidergoo · 08-23-2006, 11:50 AM

Let's here it for Quillan Drinkwater!

A touch of color on these reports would make them into a gem.

silvam14 · 08-23-2006, 11:56 AM

Quote:

Originally Posted by Raidergoo

Let's here it for Quillan Drinkwater!

A touch of color on these reports would make them into a gem.

Lol! That is a good name! I'm having a great time with this universe.

The reports are bare, but only because I just whipped them up and wanted to get them out for opinions ASAP. I can always mess with the eye candy!

08-23-2006, 11:50 AM	#5
Raidergoo Hall Of Famer Join Date: Mar 2003 Posts: 9,005	Let's here it for Quillan Drinkwater! A touch of color on these reports would make them into a gem.