Newer versions of Access Office Integration (AOI) have built in upload templates designed to replace the old Standalone ones. These can be accessed as follows:
In Excel,select the ACCESS option from the ribbon.
In the ribbon, click on the text Select Upload Template from the Create Sheet dropdown menu.
Choose the required upload template and populate with the required information.
Once set up, the excel workbook can be saved for later use just as the old standalone versions could.
