title: What is the proper way of running access macro from sql server agent job scheduler
body: <p>I have requirement of automating the process of running macros to fill sql tables. I am using a sql server job scheduling agent for this. Here is my macros batch file:</p>
  
  <p><strong>"C:\Program Files\Microsoft Office\root\Office16\MSACCESS.EXE" "C:\Users\stiwari\Documents\access_table.accdb" /x upload</strong> </p>
  
  <p>These commands work when executed as a batch file from command prompt and the data moves to SQL db. They also work when executed in windows task scheduler. However this syntax doesn't work when using a cmd job task in SQL server. 
  I have even enabled proxy credentials still it doesn't work. 
  I get this error all the time:</p>
  
  <p><strong>The step didn't generate any output. Process Exit Code-1073741502. The step failed.</strong></p>
  
  <p>What can be the reason?</p>