طيب طبقنا هذا الكود للمقارنة بين حقول الجدولين .....
DoCmd.TransferSpreadsheet acImport, acSpreadsheetTypeExcel8, "Tablex", m_strFileName, True
Dim s As Integer
Dim dbss As Database, tdf1 As TableDef
Dim dbs As Database, tdf As TableDef
Dim fld, fld1 As Field
Dim tbl, tbl1 As String
tbl = "Table"
tbl1 = "Tablex"
Set dbs = CurrentDb
Set dbss = CurrentDb
Set tdf = dbs.TableDefs(tbl)
Set tdf1 = dbss.TableDefs(tbl1)
For Each fld In tdf.Fields
s = 0
For Each fld1 In tdf1.Fields
If fld.Name = fld1.Name Then s = s + 1
Next fld1
If s = 0 Then GoTo dd
Next fld
Set dbss = Nothing
Set dbs = Nothing
DoCmd.SetWarnings False
DoCmd.OpenQuery "import_tbl"
DoCmd.DeleteObject acTable, "Tablex"
DoCmd.SetWarnings True
txtImportFile = ""
MsgBox "Data imported successfully"
Exit_أمر8_Click:
Exit Sub
dd:
MsgBox "هناك اختلاف في اسماء الحقول"
DoCmd.SetWarnings False
DoCmd.DeleteObject acTable, "Tablex"
DoCmd.SetWarnings True
تفضل ملفك بعد التعديل .....
Access Import.accdb