Raymond TamJun 19, 20201 minHow to Read File in Excel FormulaLet's say you have a system that outputs a text file every day for you automatically and you need the data in the file in your Excel...
Raymond TamJun 16, 20201 minWhy use ajMergeRec?The ajMergeRec function update records in databases if it exists. Otherwise, it’ll create a new record. Imagine you need to update your...
Raymond TamJun 11, 20201 minHow to use ajExecuteSqlThe ajExecuteSQL function executes a SQL Statement and then returns the result. We can use this in Excel to allow users to execute SQL...