Ask The Expert Recurring Series on May 25, 2021 (Monarch & Automator)


Ask The Expert Series on May 25, 2021   
(Monarch & Automator)

 

The Session began with a brief overview of opening MS-Excel & MS-Access data sources/files followed with how to bring in data using ODBC, OLEDB, & SQL Server connections before diving into the LIVE Questions. 

Monarch Question: 

  1. Explained the differences of 32-bit & 64-bit connections. - Mo explained and demonstrated in how to locate -bit connection on one's machine. 

 

Automator Question:

  1. How to call a stored procedure with date parameter?  - Mo demonstrated
  2. What would it take to get the current date variable & pass it to the stored procedure? - It was mentioned they may be able to utilize the "Get Date" function.