Accessing MS-ACCESS tables without PCFILES

Reply
Respected Advisor
Posts: 4,919

Accessing MS-ACCESS tables without PCFILES

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.

PG
Super User
Posts: 3,250

Re: Accessing MS-ACCESS tables without PCFILES

[ Edited ]

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

 

Super User
Posts: 10,018

Re: Accessing MS-ACCESS tables without PCFILES

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;

Ask a Question
Discussion stats
  • 2 replies
  • 230 views
  • 0 likes
  • 3 in conversation