Problem Note 34240: An error occurs when you try to read Visual FoxPro DBF Files with the IMPORT procedure
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
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
SAS/ACCESS Interface to PC Files
Microsoft Windows XP 64-bit Edition
Microsoft Windows Server 2003 Enterprise 64-bit Edition
Microsoft Windows Server 2003 Datacenter 64-bit Edition
Microsoft® Windows® for 64-Bit Itanium-based Systems
Microsoft® Windows® for x64
Microsoft Windows 95/98
Microsoft Windows 2000 Advanced Server
Microsoft Windows 2000 Datacenter Server
Microsoft Windows 2000 Server
Microsoft Windows 2000 Professional
Microsoft Windows NT Workstation
Microsoft Windows Server 2003 Datacenter Edition
Microsoft Windows Server 2003 Enterprise Edition
Microsoft Windows Server 2003 Standard Edition
Microsoft Windows XP Professional
Windows Millennium Edition (Me)
For software releases that are not yet generally available, the Fixed
Release is the software release in which the problem is planned to be