Explain the method you implemented for importing multiple restock files and updating the inventory items

What will be an ideal response?

To accommodate the possibility of importing multiple delimited files containing additional items to add to inventory, a combination of VBA and a macro was used. A VBA procedure was created to display a file dialog window to select multiple files. The files are imported into a table tblRestock, and then a macro that I created is called to run an update query to add the values in the tblRestock table to the items in the tblInventory table. After the process is completed, the data in the tblRestock table is deleted.