Macro compile time error

[pavan81]

Hi All,

i have query i have table with 57 fields in sqlserver and when i writing query in macro it showing syntax error. .

and my query is
>>> use code - tags <<<

conn.Execute "insert into dbo.MASTER_DATA (DATE,   CALL_ID,    CHANNEL,    REGION, AREA,   ANCHOR_ZONE,    REPORTING_MANAGER,  TBIZONE,    TBI,    TBI_ID, ROLE_ID,    DESIGNATION,    TBI_CONT,   WAREHOUSE_ID,   DBR_CODE,   DBR,    ORDERDONEBY_WAREHOUSE,  BEAT_ID,    BEAT,   OUTLET_ID,  OUTLETNAME, OUTLET_ADDRESS, OUTLET_TYPE,   .......57)" & _
        "values ('"&DTRANGE&"', '"&C_ID&"', '"&CHANNEL&"',  '"&REGION&"',   '"&AREA&"', '"&AZONE&"',    '"&RM&"',   '"&TZONE&"',    '"&TBI&"',  '"&TBI_ID&"',   '"&ROLEID&"',   '"&DESG&"', '"&TBI_CONT&"', '"&W_ID&"', '"&DBRCODE&"',  '"&DBR&"',  '"&ODBW&"', '"&BEATID&"',   '"&BEAT&"', '"&OLSID&"',    '"&OLSNAME&"',  ........')"

Plz help me.

Regards
Pavan