"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