topic Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data in Microsoft Integration with SAS

The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

BritAshley — Thu, 15 Jan 2015 16:51:03 GMT

I reinstalled SAS 9.3 on to my computer today, and when I went to import an Excel file, I got the following error:

The SAS/ACCESS Interface to PC Files is not installed

However, I ran

proc setinit;

run;

And the SAS/ACCESS Interface to PC Files is listed under the products that are installed.

If I reinstall, is there a way to ensure that this piece will be installed correctly?

Thanks!

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

KevinL70 — Thu, 15 Jan 2015 17:53:24 GMT

Hello BritAshley,

Make sure that SAS PC Files Server is installed and running.

If you are using Windows 7 you can check by clicking on the Start Icon and typing in services and hitting enter. You should find the entry called: "SAS PC Files Server" and it should say "Started" under Status.

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

BritAshley — Thu, 15 Jan 2015 18:00:03 GMT

Hi KevinL70,

I do not think I need SAS PC Files Server because I have 32-bit MS Office and 32-bit SAS. I believe I am having problems with the SAS/ACCESS Interface to PC Files.

Thanks!

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

KevinL70 — Thu, 15 Jan 2015 18:12:17 GMT

Hi BritAshley,

According to the SAS documentation, I believe the SAS PC Files Server needs to run regardless if a PC is 64 or 32 Bit:

SAS/ACCESS(R) 9.3 Interface to PC Files: Reference

Thanks,

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

SASKiwi — Thu, 15 Jan 2015 18:31:48 GMT

BritAshley is correct. If the "bitness" between SAS and Office is the same no PC File Server is required. Where I work we use 64-bit SAS and MS Office components and it works fine.

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

Reeza — Thu, 15 Jan 2015 19:07:53 GMT

What's your code then? How are you trying to import your file?

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

BritAshley — Thu, 15 Jan 2015 19:23:56 GMT

Hi Reeza,

I can import csv and txt files, just not MS office files (Excel/Access). I was using proc import to do it.

Thanks

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

Reeza — Thu, 15 Jan 2015 19:26:03 GMT

Do you have the license for the product?

Run

proc setinit; run; to see if it's licensed and

proc product_status; run; to see if it's installed.

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

BritAshley — Thu, 15 Jan 2015 19:31:15 GMT

Thank you, okay, it was on the list of licensed products, but NOT on the list of installed products. However, I know I clicked the box to install it when I installed SAS.

Re: The SAS/ACCESS Interface to PC Files is not installed error when importing Excel data

SASKiwi — Thu, 15 Jan 2015 19:38:19 GMT

Try re-installing, using the additional software option.