وعليكم السلام 🙂
انا استعمل هذه الطريقة:
mySQL = "insert into T1"
mySQL = mySQL & " ([a],,[c],[d],[e],[f],[g],[h],,[j],[k]) values('"
mySQL = mySQL & " & " & rs.Fields(1) & "', '"
mySQL = mySQL & " & " & rs.Fields(2) & "', '"
mySQL = mySQL & " & " & rs.Fields(3) & "', '"
mySQL = mySQL & " & " & rs.Fields(4) & "', '"
mySQL = mySQL & " & " & rs.Fields(5) & "', '"
mySQL = mySQL & " & " & rs.Fields(6) & "', '"
mySQL = mySQL & " & " & rs.Fields(7) & "', '"
mySQL = mySQL & " & " & rs.Fields(8) & "', '"
mySQL = mySQL & " & " & rs.Fields(9) & "', '"
mySQL = mySQL & " & " & rs.Fields(10) & "', '"
mySQL = mySQL & " & " & rs.Fields(0) & "')"
DoCmd.RunSQL mySQL
جعفر