PRB: Import Wizard Fails Reporting "No Fields Were Found"

MORE INFORMATION

The Import Wizard looks at only the active sheet in the Excel workbook.

Another way to import a sheet from an Excel 5.0 workbook is to use the Import command on the File menu. The dialog box displayed by the Import command has a drop-down list box where you can choose a specific sheet from an Excel workbook. Of course, the sheet containing the data would have to be known. The Import command echoes the following command into the Visual FoxPro Command window assuming an Excel file named Abc.xls and Sheet 7 is chosen in the Sheet drop-down list box. You can then issue this command either in the Command window or in a program.