Excel query

[Parker]

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

 

[Fredrik Wahlgren]

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_d...l_(ADO)_using_VBA_in_Microsoft_Excel/427.html

Best Regards,
Fredrik