| | While there is a systematic methodology for determining internal table names, it can be a daunting skill to master. By far, the easiest method for determining an internal table name is to use the Office Connector function wizard.
The Easy Way
The following steps illustrate the simplest method for determining an internal table name:- Set the active cell to an unused location
- Click the
 Count Wizard toolbar button. - Select the desired table and click Finish.
- The internal table name is listed as the first parameter of the TSCount formula.
For Large Tables
Some tables, especially transaction tables, can contain a very large number of records. In these cases, it may take a significant amount of time for the TSCount function to return a value. To avoid loading the entire table to get just the table name, you can use the following trick:- Set the active cell to an unused location
- Click the Count Wizard toolbar button.
- Select the desired table and click Next.
- Check the Show advanced view box.
- Paste the following text into the large text box: Where 1=0
- Click Finish.
- The internal table name is listed as the first parameter of the TSCount formula.
See Also
|