When using the SAS/ACCESS Interface to PC Files engines, you might receive the following errors:
ERROR: Connect: Class not registered
ERROR: Error in the LIBNAME statement
Use the following flow chart to diagnose and circumvent these issues:
References:
- SAS KB0036451: "Identify the Microsoft ACE components installed"
- Learn about XLSX and XLS engine details in the "Microsoft Excel Workbook Files" section of SAS/ACCESS® 9.4 Interface to PC Files: Reference, Fourth Edition
- "Quick Start for Installation" section in SAS® 9.4 PC Files Server: Installation and Configuration Guide, Second Edition
- Microsoft Access 2013 Runtime Download