topic SAS/ACCESS Interface to PC Files in Administration and Deployment

SAS/ACCESS Interface to PC Files

eyespike1 — Thu, 31 Oct 2013 17:00:18 GMT

Hi, we just installed EM 12.3 previous version EM 12.1

When importing excel files I am seeing the following error in the log file:

The SAS/ACCESS Interface to PC Files is not installed. Please install this module in order to IMPORT/EXPORT to these file types.

I am able to import text files.

I have installed the SAS drivers for ODBC "Client Version" but the error persists.

This is a stand alone workstation version with no connections to external servers. 64 bit.

Thanks for any help

Seth

Re: SAS/ACCESS Interface to PC Files

NoahPowers — Thu, 31 Oct 2013 17:13:39 GMT

Seth,

Here is a SAS Note that I found helpful in sorting it out. If you still are unsuccessful in getting it to work after using the following link then I would suggest contacting sas tech support.

43802 - Installing SAS® 9.3 PC Files Server and using it to convert 32-bit Microsoft Office files to SAS® 64-bit files

Noah

Re: SAS/ACCESS Interface to PC Files

SASKiwi — Thu, 31 Oct 2013 18:56:06 GMT

I suggest you first confirm that SAS/ACCESS Interface to PC Files is in your current licence - run proc setinit noalias; run; Typically SAS will install all licensed products unless you explicitly change your product selection.

If it is included then you may need to go through the install again selecting SAS/ACCESS Interface to PC Files as an additional product.