Your string concatenation in the SQL Select is incorrect. Use something like this currentSchedule = new OleDbCommand("INSERT INTO Suite_Schedule( SId, SName, P, S, C, RR, ProjectId, ScheduleTime, SStatus ) SELECT SId, SName, P, S, C, RR, ProjectId, '" + schedule.ScheduledTime.ToString("G") + "', 'Test' FROM Suite WHERE SId= "+ schedule.SID +" ",dbConnection); ---------- user9 A student knows little about a lot. A professor knows a lot about little. I know everything about nothing.