upload data from Microsoft acces to Sql server
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.