Import Table from Excel or Flat File
Creating a Table from an Excel file is easily done with the Create Table Wizard, Click on Create Table (1) from the Start Page and Import Table from Excel or FlatFile (2)
Before we begin importing, download the Excel file to your Computer: AW_Product_Master.xlsx
Click Browse.. and navigate to the downloaded file., Modify the Table Name to Product and Click on Next.
Change the configuration mapping, change the Project to Product Master. Change Datatype of Safety Stock Level toNumber and Sell Start Date to DateTime.
Click Verify to go to the Next Step.
If all looks good click on Confirm to start importing.
Import should now be final, click on Close and imported data should be visible in the table.