How do I import 32bit excel sheet into a 64 bit sas 9.4

[ss123]

I have been trying to find ways to import my 32bit microsoft excel 2010 and I found the PC file server installation guide (SAS/ACCESS(R) 9.4 Interface to PC Files: Reference, Second Edition). However, it is a little confusing and I was wondering if any of you have done it and tell me about your experience.

My laptop is a windows 7.

Thanks.

[jakarman · Accepted solution]

It is not that difficult, You need to install the 32-bit version of PCfiles-server.

Your SAS code need to be changed to using the tcpip connection to that PCfiles-server. By that it will go from a 64-bit to 32-bit process.

The technical reason it the ACE-driver being part of MS-office. That driver is doing all the conversions.  

With xlsx files (Zip files containing XML files) this is not necessary any more, but SAS is still doing this.

Other solutions could be:  

- Use 64-bit Ms-office

- Transport your data using CSV or XML (do the conversion outside SAS / Office) 

- Go fo a server-approach wit AMO (Addin Microsoft Office)

It is a usual question. DBMS interfaces and many more are having the same kind of bit-ness issues.

http://www.linkedin.com/groupItem?view=&gid=70702&type=member&item=5869814871612235778&qid=d26176d7-...

[ss123]

Thanks! It took me so long is because I didn't find any pc server file for sas 9.4, but now they have it!

[Ksharp]

You can make a ODBC connection for that excel file, But it would be cumbersome and clumsy .