I am using the following code to import data through an MS Access 2010 form:
Private Sub ImportSurveyP_Click()
If IsNull(Me.txtFileName) Or Len(Me.txtFileName & "") = 0 Then
MsgBox "Please select the Excel file"
DoCmd.TransferSpreadsheet acImport, 10, "data_Survey", Me.txtFileName, True
Me.ImportSurveyP.Enabled = False
If one of the fields of the import file contains a data type that does not match with the database specifications, the usual "Sheet1$_ImportErrors" table is generated to list which field(s) and record(s) were in error. However, Access does not show the typical warning message that the errors occurred and the error table was generated.
How can I get this warning message to appear when importing with VBA?
Note: Confirm Record changes, Document deletions, and Action queries are all checked in Options. Is there another Option setting I need to make?