Vba Adodb query error

Question

I have excel sheet like this

RETAIL_SKU  STUDIO_NAME REGION  MERCHANT    SOURCE_TYPE RETOUCH_LEVEL   

CCCF9X55FI  CCRY1B          EU  Buy VIP     Studio       9   
CCCHB1Z8EE  PCCL3B          NA  Buy VIP     Studio       9   
CCCFECJQ1I  LEJ1A           EU  Buy VIP     Studio       9   
CCCH296DN0  CCRY1B          EU  Buy VIP     Studio       9   
CCCEQR38LQ  PCCL3B          NA  Buy VIP     Studio       9   
CCCHSC2X0I  PCCL3B          NA  Buy VIP     Studio       9   
CCCA0IY4OU  BV-DE-RETAIL    EU  Buy VIP     Vendor       9   
CCCGX64C68  PCCL3B          NA  Buy VIP     Studio       9   
CCCG7U7W4O  CCRY1B          EU  Buy VIP     Studio       9

Looking result like this

STUDIO_NAME REGION
CCRY1B            3
PCCL3B            4
LEJ1A             1
BV-DE-RETAIL      1

i'm trying to achieve this though Ado-db .But i havent found any solution so far.

This is my below code which i have tried

str = "SELECT STUDIO_NAME,COUNT(*) RETAIL_SKU FROM [Sheet7$] WHERE MERCHANT='Buy VIP' AND RETOUCH_LEVEL=9 GROUP BY STUDIO_NAME"
rsEx.Open str, ConEx, adOpenKeyset, adLockOptimistic ' this is where i'm getting error

i getting the below error

enter image description here

sam092 · Accepted Answer · 2014-03-24 08:23:27Z

1

Your SQL statement should be like this

SELECT STUDIO_NAME,COUNT(*) AS REGION FROM [Sheet7$] WHERE MERCHANT='Buy VIP' AND RETOUCH_LEVEL=9 GROUP BY STUDIO_NAME

answered Mar 24, 2014 at 8:23

sam092

1,3251 gold badge8 silver badges8 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Vba Adodb query error

1 Answer 1

Comments

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Related