its your Values.. you are passing in field names and not data..
you either need to pass in specific data or do a select...

"INSERT INTO data_delete (ID,Fullname,ShortName) VALUES (1,'John Doe','John')"

or if you want to use variables

"INSERT INTO data_delete (ID,Fullname,ShortName) VALUES (" & ID & ",'" & FullName & "','" & ShortName & "')"

or if you want Fields

"INSERT INTO data_delete (ID,Fullname,ShortName) VALUES (SELECT ID,FullName,ShortName FROM OTHER TABLE WHERE something = somethingelse)"

Note: I am not possitive on the SQL for the last one.. its been a while since I have written and insert that selects.. but the idea is there