Desktop productivity for business analysts and programmers

import and export im ms access on windows os

Reply
Contributor
Posts: 74

import and export im ms access on windows os

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

Super User
Posts: 1,092

Re: import and export im ms access on windows os

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...

Respected Advisor
Posts: 4,606

Re: import and export im ms access on windows os

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.

PG
Ask a Question
Discussion stats
  • 2 replies
  • 213 views
  • 1 like
  • 3 in conversation