import and export im ms access on windows os

[TarunKumar]

Dear Team ,

Any an idea how we can import sasdata set in ms access. by import wizard i am able to do the import & export. but i want to done by sas coding.

Regards

Tarun Kumar

[JuanS_OCS]

If you have the license of SAS/ACCESS Interface to PC Files, which I guess you do, you can use libname statements, then access the data with data steps or proc sql statements:

http://www2.sas.com/proceedings/sugi27/p025-27.pdf

http://support.sas.com/documentation/cdl/en/acpcref/63181/HTML/default/viewer.htm#p0psac3j16cioen1nq...

[PGStats]

Are your versions of MS-Office and SAS of the same "bitness" (32 or 64 bits)? If not, you are trapped into using SAS PCFILES server which provides some, but not all, of the SAS-Office interface. 

After wasting some time on this issue, we switched back from 64 to 32 bits versions of SAS, until we are ready to upgrade Office to 64 bits.