upload data from Microsoft acces to Sql server

Aug 26 2004 12:26 AM
UPDATE [ODBC;Driver=SQL Server; SERVER=Accel-User09;DATABASE=TTSdb;UID=sa;PWD=sa;].TASK_DETAIL SET current_status = [Task_detail].[current_status], complete_date = [task_detail].[complete_Date], Duration = [Task_Detail].[Duration] WHERE Task_code=[Task_Detail].[Task_code] And [resp_Per]=[TASK_DETAIL].[RESp_PER]; the above sql statement is to update data fr ms.access to sql server.it already can detect the right database and table and right fied to update , but it inset the wrong data to the field. the need update field is current_status,complete_date,Duration cant somebody help me.