Microsoft KB Archive/92969

PRB: IMPORT FROM DIF or SYLK "Feature Not Available" Error ID: Q92969 The information in this article applies to: Microsoft FoxPro for MS-DOS, versions 2.0, 2.5, and 2.5a Microsoft FoxPro for Windows, versions 2.5 and 2.5a SYMPTOMS When the IMPORT FROM command is used to import data from a .DIF or SYLK file, a "Feature not available" error occurs. CAUSE Some copies of the "Commands & Functions" manual for FoxPro version 2.0 incorrectly state that the IMPORT FROM command can import data from .DIF and SYLK files. This feature was not implemented in FoxPro because these file formats allow variable-length columns (vectors), which complicates determining an appropriate length for a field. RESOLUTION Use the APPEND FROM command to retrieve data from a file in either the .DIF or SYLK format. The following steps illustrate how to import data from a .DIF file (called MYDATA.DIF) into FoxPro: 1. Create a new database in FoxPro and define the appropriate structure to receive the imported data. 2. Issue the following command in the Command window: APPEND FROM mydata.dif TYPE DIF Note that this method adds one record that contains the names of the field names to the database. This record must be deleted. Additional reference words: FoxDos FoxWin 2.00 2.50 2.50a docerr err msg errmsg prb problem silk KBCategory: kbprg kberrmsg kbprb kbdocerr KBSubcategory: FxprgGeneral

Last Reviewed: June 27, 1995 © 1999 Microsoft Corporation. All rights reserved. Terms of Use.