How to create a data source to access Excel files (130732)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft Visual FoxPro for Windows 6.0
- Microsoft Visual FoxPro for Windows 7.0
- Microsoft Visual FoxPro 8.0
- Microsoft Visual FoxPro 9.0 Professional Edition
This article was previously published under Q130732 SUMMARY
This article describes how to create a data source to access Microsoft
Excel files by using ODBC.
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.
| Modification Type: | Major | Last Reviewed: | 2/24/2005 |
|---|
| Keywords: | kbhowto KB130732 kbAudDeveloper |
|---|
|