The Excel 2002 Add-in: Open Database Connectivity (ODBC) contains the SQL.REQUEST worksheet function. The SQL.REQUEST worksheet function is used to link to an external data source, run a query, and return the result of a query to the worksheet. Once your query is complete, you can use Microsoft Excel's many features to analyze your data.
Note This add-in also includes several Visual Basic for Applications (VBA) functions that can be used to connect to an external data source. Do not use these functions when writing new procedures; use the objects, methods, and properties in the Microsoft ActiveX Data Object (ADO) library instead.
|