Hi I am tring to insert into a table a record from afile dialog box , but if the record exists in the table i am inserting into I want it to not insert and drop the record.
Code:
Sub Letters()

DoCmd.SetWarnings False
Dim FileDate As String
Dim LetterCode As String
Dim MyArray As Variant
Dim fd As FileDialog
Dim updatesql As String
Dim FileName As String
Dim XLApp As New Excel.Application
...