Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2000 - Autofilter Limit | Excel Worksheet Functions | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
How to limit number of rows Excel? | Excel Discussion (Misc queries) | |||
Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) | |||
How do I limit the number of rows in an Excel worksheet. | Excel Worksheet Functions |