How to create a data source to access Excel files

MORE INFORMATION

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.