hi.
i finally finished - with the help of the forum's own great pbaldy - the query that i was going to use as the data feed for my Excel 2007 pivot table.
everything seemed to be working initially - i insert the pivot table, find my query in the 'External Connection...' dialog, the "Reading Data:" counter is counting, the data is flowing in, i am about to open a beer, when - it stops! at 7000 something. out of only about 10000!
and displays the following messages -
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
and then
Problems obtaining data.
what is it? can anything be done to improve this exceeded 'resource' a bit?..
thanks,
l
i finally finished - with the help of the forum's own great pbaldy - the query that i was going to use as the data feed for my Excel 2007 pivot table.
everything seemed to be working initially - i insert the pivot table, find my query in the 'External Connection...' dialog, the "Reading Data:" counter is counting, the data is flowing in, i am about to open a beer, when - it stops! at 7000 something. out of only about 10000!
and displays the following messages -
[Microsoft][ODBC Microsoft Access Driver] System resource exceeded.
and then
Problems obtaining data.
what is it? can anything be done to improve this exceeded 'resource' a bit?..
thanks,
l
