SQL.REQUEST(connection_string, output_ref, driver_prompt, query_text, col_names_logical)Ĭonnects to an external data source and executes a query.Ĭonnection_string - The data source name, user id and password required by the driver. The add-in has the filename "XLODBC.xla" and was installed in the following folder by default:Ĭ:\Program Files\Microsoft Office\Office10\Library\Msquery\ This add-in was not installed as part of the normal installation but could be downloaded from the Microsoft website. This is short for Open Database Connectivity and allows you to connect to external data sources using ODBC drivers and the SQL.REQUEST function. This was replaced with ActiveX Data Objects.
0 Comments
Leave a Reply. |