Excel query
 

Hi,



I'm using Microsoft Query to get data from my Access tables. After the 64th
query, I get the message "[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed", which means I can't add another query. I need
several more queries. Each query has 53 fields. Can I increase the number of
queries the driver can open some way? If not can, pivot tables or OLAP cubes
open more queries. I have played with them some. Can they open that many
fields? Are pivot tables or OLAP cubes the best way to handle the data?



I'm not looking for a 'how to' answer just to point me in the right
direction and I can experiment from there. I'm using Office XP sp3.



Thanks

"Parker" wrote in message
...
Hi,

I'm using Microsoft Query to get data from my Access tables. After the
64th
query, I get the message "[Microsoft][ODBC Driver Manager] Driver's
SQLSetConnectAttr failed", which means I can't add another query. I need
several more queries. Each query has 53 fields. Can I increase the number
of
queries the driver can open some way? If not can, pivot tables or OLAP
cubes
open more queries. I have played with them some. Can they open that many
fields? Are pivot tables or OLAP cubes the best way to handle the data?


I'm not looking for a 'how to' answer just to point me in the right
direction and I can experiment from there. I'm using Office XP sp3.

Thanks


Maybe you can use ADO and a macro to pull data you want. Here's sample code
http://www.exceltip.com/st/Import_data_from_Access_to_Excel_(ADO)_using_VBA_i n_Microsoft_Excel/427.html

Best Regards,
Fredrik