ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Limit in the number of Dataqueries in Excel 2000 (https://www.excelbanter.com/excel-programming/273492-limit-number-dataqueries-excel-2000-a.html)

Deva[_2_]

Limit in the number of Dataqueries in Excel 2000
 
Hi,
We have an excel addin from a third party vendor that is
supposed to use dataqueries in Excel to update data in an
Excel sheet from a Fox Pro database every 5 mins. The
addin uses excel Querytables to retreive the values from
the FoxPro database. We have around 175 Query tables in
one sheet. We then make a copy of the sheet and insert
into a another sheet. Bu this time we get the following
error the next time the querytables try to refresh:
[Microsoft][ODBC Visual FoxPro Driver]Too many variables.
Just wanted to see if this was a limitation on the number
of Querytables an excel workbook can have.

Thanks,
Deva


All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com