How to create a data source to access Excel files

View products that this article applies to.

This article was previously published under Q130732

Expand all | Collapse all

SUMMARY

This article describes how to create a data source to access Microsoft Excel files by using ODBC.

In the data source setup dialog box, specify the version of the Microsoft Excel file that you want to connect. If it is a file in Excel 5.0 a later version of Excel, you also need to specify the name of the workbook. The workbook in a file in Excel 5.0 or a later version of Excel is analogous to the Visual FoxPro database, and the Microsoft Excel worksheet is analogous to the Visual FoxPro table.

If you specify an Excel version 4.0 or 3.0 file, you must also specify the directory where the file is located. In this case, the directory is analogous to the Visual FoxPro database, and the Excel spreadsheets are analogous to the Visual FoxPro table.