The following error might be returned if you try to run the IMPORT procedure in SAS^® 9.1.3 SP4 and SAS^® 9.2 to read a DBF file that is created with Visual FoxPro 9.0 Professional SP2:

PROC IMPORT OUT= WORK.TEST
             DATAFILE= "C:\data\FoxPro9\ORDERS.DBF"
             DBMS=DBF REPLACE;
 RUN;

ERROR: Invalid or non-supported file specified.
NOTE: The SAS System stopped processing this step because of errors.

The DBASE engine in SAS/ACCESS^® Interface to PC Files in SAS 9.x cannot read the FoxPro DBF file.

There are two possible workarounds to reading the files:

• Use SAS/ACCESS^® Interface to ODBC with the Microsoft Visual Foxpro ODBC driver.
• Use SAS/ACCESS^® Interface to OLE DB in combination with the Microsoft OLE DB Provider for Visual FoxPro 9.0. This Provider supports both DBF and DBC files, as well as memo fields.

Operating System and Release Information