How to Import Records from Excel Using X++ Code in D365FO

  How to Import Records from Excel Using X++ Code in D365FO   Include the below namespace in X++ code it will requires to import Excel. Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange;   In addition to the basic reference, include (Directory and DirectoryUpgrade Packages) X++ Code: Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange; class ReadExcel {   public static void main(Args _args)    {     Int id;     Str Name;      System.IO.Stream stream;       ExcelSpreadsheetName sheet;              FileUploadBuild fileUpload,fileUploadBuild;       DialogGroup dialogUploadGroup;       FormBuildControl formBuildControl;   ...

How to connect to SQL database in SAT


How to connect to SQL database in SAT



Copy SQL server name and append .database.windows.net that it becomes:
<SQL server name>.database.windows.net
Use this string to connect to the database in SQL Server Management Studio.


Comments

Popular posts from this blog

Passing Args from one Form to another Form in dynamics AX

D365 FO: REFRESH CALLER FORM DATA SOURCE FROM A CLASS X++

CREATE AND POSTING PURCHASE ORDER THROUGH X++ DYNAMICS AX