Code:
$ awk '{printf ("INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (%s\,%s,\"%s\",%s,\"%s\",\"\");\n",$1,$2,$3,$4,$5)}' query
awk: warning: escape sequence `\,' treated as plain `,'
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (07/07/2008,21:18:51,"Installation",52016,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (07/21/2008,15:28:15,"Removal",52016,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (07/21/2008,15:34:15,"Removal",55856,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (12/08/2009,19:30:40,"Installation",62323,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (12/08/2009,19:39:06,"Installation",64869,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (12/09/2009,15:11:24,"Preview",63753,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (12/09/2009,15:16:21,"Installation",63753,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (01/20/2011,14:39:50,"Preview",76441,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (01/21/2011,8:56:40,"Preview",76699,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (01/24/2011,12:55:05,"Installation",76441,"complete","");
INSERT INTO example (Date,Time,Type,Number,Status,Notes) VALUES (01/24/2011,12:58:24,"Installation",76699,"complete","");