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
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

 

[vletm]

pavan81
Why did You duplicate Your thread?

Macro compile time error

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

chandoo.org

You can continue with Your original thread.
This is closed.