Why doesn Query list all the tables in the target data source?
Microsoft Query issues the SQLTables() ODBC API call. This API call takes several arguments: TABLE, VIEW, SYNONYM, etc. Microsoft Query only asks for TABLE; our ODBC driver therefore correctly leaves out the VIEWs and other table types. We have introduced an enhancement into our driver to work around this issue. That said, you can manually create any query you like; the limitation only affects the graphical query builder.
Related Questions
- Where can I find a list of the tables and a list of the names of all of the data fields in the CA iprogram to assist with using the Ad Hoc Reporting feature?
- Where can I find a list of the tables and a list of the names of all of the data fields in the CAi program to assist with using the Ad Hoc Reporting feature?
- Ive inherited workbooks with pivot tables based on an Access query. How can I find what the data source is?
