Query Tables Methods

Name Returns Description

Add QueryTable Method. Parameters: Connection, Destination As

Range, [Sql]. Adds a QueryTable to the collection. The Connection parameter can specify the ODBC or OLE DB connection string, another QueryTable object, a DAO or ADO recordset object, a web-based query, a Data Finder string, or a text file name. The Destination parameter specifies the upper-left corner that the query table results will be placed. The SQL parameter can specify the SQL for the connection, if applicable

0 0

Post a comment