Originally Posted by Chrome Prince
You can either do most of your queries within the database or there is the option to dump the whole lot to excel for your own personal filtering needs.
Often I run a basic query and dump the results into excel in order to do calculations through excel.
One small point, you cannot dump the whole lot into anything other than Excel 2007, you will have to break it up into lots of two or three years, if dumping everything, as previous versions of Excel have a row limit of 65,536 rows.
You could of course dump the whole lot into Access.
|