Suggest add an option to PCFILES engine so when used on a libname statement, can specify whether the file is an Access file or Excel file, instead of relying on the file extension.
Currently, looks like file extension must be .mdb | .accdb | .xls | .xlsx | .xlsb so that PCFILES engine can guess which file type it is.
Some peole still rename files with odd extensions in order to get them through email filters etc. Would be nice to be able to read these files without being forced to rename the extensions.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.