Microsoft KB Archive/130732

= How to create a data source to access Excel files =

Article ID: 130732

Article Last Modified on 2/24/2005

-

APPLIES TO


 * Microsoft Visual FoxPro 3.0 Standard Edition
 * Microsoft Visual FoxPro 6.0 Professional Edition
 * Microsoft Visual FoxPro 7.0 Professional Edition
 * Microsoft Visual FoxPro 8.0 Professional Edition
 * 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.

Additional query words: VFoxWin

Keywords: kbhowto KB130732

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.