Both of you guys were correct. I have added the delimiters for DATE. I removed the .Value on the fields. June7 is absolutely corrent, the cenSQL and endSQL hold the comma/apostrophe combinations for joining VALUES. I removed the database name from the Table designation in the SQL.
The output from the debug is:
Code:
INSERT INTO Materials1 (WPSNo, SetNo, PartNo, GroupNo, GroupTo, Alloy, AlloyTo, HTCond, HTCondTo, Thickness, ThicknessTo, FormSheet, FormSheetTo, Thickest, Thinnest)VALUES ('','1','','','','','','','','','','','','','');
And it is absolutely correct!!!! It works great now. Last night this problem almost drove me to drinking. Thank you so much June7 and ssnafu. I really appreciate it.