title: SAS Access Database Export : Connection failed
body: <p>I am trying to export SAS Dataset to my local in ".mdb" format (Access Database). I am using Proc Export statement but it gives the error "Connection Failed"</p>
  
  <p>Also, When I tried to achieve this using EG "Export" feature (on top of the editor window), I used "Export xyz as a step in Project" , I could not find access format there though excel, txt etc options were available.</p>
  
  <p>I did Proc Setinit and found that SAS/Access interfact to PC Files is installed. </p>
  
  <p>I am using SAS 9.4, SAS EG 7.12 and Access 2013. The code I used is as below -</p>
  
  <pre><code>     proc export data=test 
      dbms= ACCESS
       outfile="M:\SASAnalytics\Test\test1.mdb" 
      replace;
      run;
  </code></pre>
  
  <p>And When I tried assigning the libname using </p>
  
  <pre><code>    libname mdb "M:\AFolder\BFolder\C.mdb"
  </code></pre>
  
  <p>I got this error - ERROR: Connect: Class not registered.</p>
  
  <p>I guess, there is nothing with the code but the SAS Access Export is not enabled or something. Please suggest what could be the issue and how to resolve that?</p>