You can also set a reference to excel in Access, and then use the application object to turn off the warning in excel before doing the import.

Dim objXL As Excel.Application
Dim objWkb As Excel.Workbook
Set objXL = New Excel.Application
‘turn off excel warnings
objXL.DisplayAlerts = False
‘Open the Workbook
Set objWkb = objXL.Workbooks.Open(fpath)
‘import excel object
DoCmd.TransferSpreadsheet acImport, 8, “applicantImport”, fpath, True, “A1:V10000″