topic Re: Accessing MS-ACCESS tables without PCFILES in SAS Programming

Accessing MS-ACCESS tables without PCFILES

PGStats — Thu, 25 Feb 2016 18:05:46 GMT

Hello, is there an alternative to the PCFILES server to access MS-ACCESS 32 bits data from SAS 64 bits? Both programs are running on the same Win7-64 machine.

Re: Accessing MS-ACCESS tables without PCFILES

SASKiwi — Thu, 25 Feb 2016 19:35:12 GMT

Two options:

Microsoft 64-bit ACE engine - download from Microsoft. This can be used with 64-bit SAS/ACCESS to PC Files.
ODBC can be used. You would need SAS/ACCESS to ODBC installed and licensed though:

http://support.sas.com/documentation/cdl/en/bidsag/68193/HTML/default/viewer.htm#n167cjb87i0x9wn1h1qynnb2zumc.htm

Re: Accessing MS-ACCESS tables without PCFILES

Ksharp — Fri, 26 Feb 2016 02:26:44 GMT

Did you try proc import ? I also doubt if this could work, since Excel can't work in this case.

proc import database='......' datatable='.......' dbms=access replace;run;