title: SAS proc import xlsm files
body: <p>I would like to do proc import for xlsm data.</p>
  
  <pre><code>proc import
      out = outdata
      datafile = "C:\User\Desktop\data.xlsm"  
      dbms = excelcs replace;
      sheet = "SheetA";
  run;
  </code></pre>
  
  <p>The error message is:</p>
  
  <pre><code>ERROR: CLI error trying to establish connection: [Microsoft][ODBC Excel Driver]General error
         Unable to open registry key Temporary (volatile) Ace DSN for process 0x4058 Thread 0x3dc0
         DBC 0x2c1780c                                                            Excel'.
  ERROR: Error in the LIBNAME statement
  </code></pre>
  
  <p>When i use dmbs=excel instead; i got following error msg:</p>
  
  <pre><code>ERROR: Connect: Class not registered
  ERROR: Error in the LIBNAME statement.
  </code></pre>