3rd January 2008, 10:31 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,426
|
|
Quote:
|
Originally Posted by nikg
Can I.... choose all default values for the query and dump the whole or close to whole database straight into excel and then create my own set of queries?
I know this sounds odd but if I can do this then I can not only use an already created database but I can extend it further into the area that I play with which would be perfect.
The only thing really stopping me from doing it all myself is I just don't have access or the contacts to get the raw data.
and if the database can do most generic system type queries then cool, but if I can dump everything and goto excel or access to do or re-do everything myself then I would have a big smile on my face !
|
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. |