KnowledgeBase Archive

An Archive of Early Microsoft KnowledgeBase Articles

View on GitHub

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

Article: Q157455
Product(s): Microsoft FoxPro
Version(s): WINDOWS:3.0,3.0b,5.0,6.0
Operating System(s): 
Keyword(s): kbvfp300 kbvfp500 kbvfp600
Last Modified: 11-DEC-1999

-------------------------------------------------------------------------------
The information in this article applies to:

- Microsoft Visual FoxPro for Windows, versions 3.0, 3.0b, 5.0, 6.0 
-------------------------------------------------------------------------------

SYMPTOMS
========

The Import Wizard in Visual FoxPro fails with the message "No fields were found
to copy" when trying to import a Microsoft Excel 5.0 workbook.

CAUSE
=====

The active sheet in the workbook is empty.

RESOLUTION
==========

Make the sheet with the data to be imported the active sheet when the Excel
workbook is saved.

STATUS
======

This behavior is by design.

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.

  IMPORT FROM abc.xls TYPE XL5 SHEET "Sheet7"

You can then issue this command either in the Command window or in a program.

REFERENCES
==========

Visual FoxPro Help; search on the Import command.

Additional query words: kbdsd VFoxWin

======================================================================
Keywords          : kbvfp300 kbvfp500 kbvfp600 
Technology        : kbVFPsearch kbAudDeveloper kbVFP300 kbVFP300b kbVFP500 kbVFP600
Version           : WINDOWS:3.0,3.0b,5.0,6.0

=============================================================================

THE INFORMATION PROVIDED IN THE MICROSOFT KNOWLEDGE BASE IS PROVIDED "AS IS" WITHOUT WARRANTY OF ANY KIND. MICROSOFT DISCLAIMS ALL WARRANTIES, EITHER EXPRESS OR IMPLIED, INCLUDING THE WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE. IN NO EVENT SHALL MICROSOFT CORPORATION OR ITS SUPPLIERS BE LIABLE FOR ANY DAMAGES WHATSOEVER INCLUDING DIRECT, INDIRECT, INCIDENTAL, CONSEQUENTIAL, LOSS OF BUSINESS PROFITS OR SPECIAL DAMAGES, EVEN IF MICROSOFT CORPORATION OR ITS SUPPLIERS HAVE BEEN ADVISED OF THE POSSIBILITY OF SUCH DAMAGES. SOME STATES DO NOT ALLOW THE EXCLUSION OR LIMITATION OF LIABILITY FOR CONSEQUENTIAL OR INCIDENTAL DAMAGES SO THE FOREGOING LIMITATION MAY NOT APPLY.