I have a button which uses the code below to import an Excel workbook. The database entirely depends on this data so its quite an important function...
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "LT_BP_Sched", strFolder & strFile, False, "SAP Input!A50:R250"
LT_BP_Sched...