problem with append query to external table 1

[vpellerito]

Hi folks. I can't seem to figure out what is wrong with my append query. I probably don't have the proper syntax by I don't know what that would be for Access.
Here is the query:

INSERT INTO dt_Field_Parameter IN 'J:\Proj\DB\MODCRCH.mdb' ([Table_Name], [sys_code], [measurement_date], [measurement_time],[param_code], [param_value], [param_unit]) 
VALUES ("1","test",#10/20/76#,"13:13","pH",7,"std units");

Thanks for your help.
Vince

 

[Golom]

INSERT INTO [red][;Database="J:\Proj\DB\MODCRCH.mdb"].dt_Field_Parameter[/red]  ([Table_Name], [sys_code], [measurement_date], [measurement_time],[param_code], [param_value], [param_unit]) 
VALUES ('1','test',#10/20/76#,'13:13','pH',7,'std units');