如何排查Microsoft Access中INSERT INTO语句的语法错误

我在Microsoft Access 2013中执行以下SQL语句时，收到报错，无法定位错误位置，在线SQL验证工具结果不一致，求排查思路：

INSERT INTO MH_Inspections ([InspectionID],[Surveyed_By],[Certificate_Number],[Owner],[Customer],[Drainage_Area],[Sheet_Number],[PO_Number],[Inspection_Date],[Inspection_Time],[Street],[City],[Location_Details],[Manhole_Number],[Rim_To_Invert],[Grade_To_Invert],[Rim_To_Grade],[Year_Constructed],[Year_Renewed],[Media_Label],[Consequence_Of_Failure],[Date_Cleaned],[AdditionalComponentInfo],[Northing],[Easting],[Elevation],[Coordinate_System],[Evidence_Surcharge],[Cover_Size],[Cover_Size_Width],[Hole_Number],[Cover_Bearing_Surface_Dia],[Cover_Bearing_Surface_Width],[Adjustment_Ring_Height],[Frame_Bearing_Surface_Width],[Frame_Bearing_Surface_Depth],[Frame_Clear_Open_Diam],[Frame_Offset_Distance],[Frame_Depth],[Chimney_Clear_Opening],[Chimney_Depth],[Cone_Depth],[Wall_Diam],[Wall_BySize],[Wall_Depth],[Channel_Installed],[Step_Number],[MH_Use],[Purpose],[PreCleaning],[Weather],[Location_Code],[Inflow_Potential_from_Runoff],[Access_Type],[GPS_Accuracy],[Inspection_Status],[Cover_Shape],[Cover_Material],[Hole_Diameter],[Cover_Frame_Fit],[Cover_Insert_Type],[Adjustment_Ring_Type],[Adjustment_Ring_Material],[Frame_Material],[Frame_Seal_Inflow],[Chimney_Material1],[Chimney_InI],[Chimney_Lining_Interior],[Chimney_Lining_Exterior],[Cone_Type],[Cone_Material],[Cone_Lining_Interior],[Cone_Lining_Exterior],[Wall_Material],[Wall_Lining_Interior],[Wall_Lining_Exterior],[Bench_Present],[Bench_Material],[Bench_Lining],[Channel_Material],[Channel_Type],[Channel_Exposure],[Step_Material],[Surface_Type_Asphalt],[Cover_Type_Vented],[Cover_Condition_Sound],[Insert_Condition_Sound],[Ring_Condition_Sound],[Frame_Condition_Sound],[Seal_Condition_Sound], [InspectionLevel], [ReportFileName]) 
VALUES (74777,"WTC/ATHOMPSON","U-0819-70306429","CoM",null,"WS04",1,"78.0152","2022-07-22","11:02","ATLANTIC ","MEMPHIS ","ATLANTIC AND HARDIN DR","WS040308",6.4,6.4,0,null,null,null,null,"2022-07-22","CHIMNEY AND CONE ARE CONCRETE BLOCK ",null,null,null, ,"N",24,4,4,23.75,23.75,null,1,1,22,0,8,25,11,4.1,48,null,5.5,"YES",3,"SS","F","Z",1,"C","S","AMH","M","RI","C","CAS","B","G","N","N",null,"CAS","N","ZZZ","N","N","N","CC","ZZZ","N","N","XXX","C","N","Y","XXX","C","CN","F","F","M",true,true,true,true,true,true,true, "2", "WS040308_MACP_WTC_20220722.pdf")

报错信息：

Syntax error in INSERT INTO statement.

• 修复空值占位错误：VALUES列表中存在null,null,null, ,"N"的空占位，Access要求空值必须明确写null，不能留空，先把该位置改为null。
• 核对字段与值的数量匹配：逐行计数INSERT INTO后的字段数和VALUES里的元素数，确保完全一致，长语句易出现逗号漏写/多写导致的数量不匹配。
• 修正日期时间格式：Access的日期时间需用#包裹，将语句中的"2022-07-22"改为#2022-07-22#，"11:02"改为#11:02#。
• 统一字符串引号：Access SQL标准语法中字符串使用单引号'，替换所有双引号"，避免语法冲突。
• 排查保留字冲突：检查字段名是否使用Access保留字，比如InspectionLevel中的Level属于保留字，确保字段名已用方括号[InspectionLevel]包裹，必要时临时重命名字段测试。
• 简化语句分步测试：先写只插入必填字段的最简INSERT语句，确认能执行后，再逐步添加其他字段/值，定位引发错误的具体内容。
• 校验数据类型匹配：确保每个值的类型对应字段类型：比如true对应Yes/No类型字段；数值类型值（如24、6.4）不要加引号；字符串类型值不要漏写引号。

内容的提问来源于stack exchange，提问作者chris_mac