Need to ignore import errors

[Abraxus]

I have some code that is used to import an Excel file of my company's employees.

Code: Select all

On Error Resume Next
    DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel12, "EmployeeListing", strCurrentDirectory & "Active Employee Listing PIT-Daily.xlsx", True
    

I'm getting the attached error and I simply want Access to know that it's always ok to import regardless of the error instead of asking me.

Is it possible to do so?

[HansV]

What happens if you insert

Code: Select all

    DoCmd.SetWarnings False

above the DoCmd.TransferSpreadsheet line, and

Code: Select all

    DoCmd.SetWarnings True

below it?

[Abraxus]

Well that was too easy...I thought On Error Resume Next would cover it.

Thank you so much!