Excel 2002 Add-in: Open Database Connectivity
Brief Description
The Excel Add-in: Open Database Connectivity (ODBC) contains the SQL.REQUEST worksheet function, which can connect to an external database and return a query to the worksheet.
On This Page
Quick Details
| File Name: | XLODBC.EXE |
| Version: | 2002 |
| Date Published: | 8/25/2001 |
| Language: | English |
| Download Size: | 163 KB |
| Estimated Download Time: | 1 min 56K |
|
| Change Language: | |
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
Top of page
What Others Are Downloading
Top of page
