Overview
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.
Top of page
System requirements
Supported operating systems: Windows 2000, Windows 98, Windows ME, Windows NT, Windows XP
- This download works with the following Office applications:
Top of page
Instructions
To install this download
- You may want to print this page to use as a reference when you are offline.
- Download the file from this page by clicking the Download link above and following the instructions in the dialog boxes.
- Double-click the XLODBC.exe program file on your hard disk to start the setup program.
- Follow the instructions on the screen to complete the installation
- Start Excel.
- On the Tools menu, click Add-ins.
- Select the ODBC Add-In check box.
- Click Enable Macros.
Instructions for use:Once you've installed the ODBC Add-in, use Excel as you normally would.
To find more information about the SQL.REQUEST worksheet function- On the Help menu, click Microsoft Excel Help.
- Type sql.request in the Office Assistant or Answer Wizard,
and then click Search to view the topics returned.
To remove this download:- Start Excel.
- On the Tools menu, click Add-ins.
- Clear the ODBC Add-in check box.
Top of page