VBA so cell range is criteria for odbc sql

[djwbaker]

Hi

I am trying to run an extract based on a range of products within excel.
I have used an odbc link but criteria remains static, looking all options up I need to write VBA to create a string based on the range and combine it to the sql

my vba is limited to autofilters, pdfs and sorting this is another level up

The range is sheet1 column A cell 2 down

my sql is

select *
from Master_Table MT
where MT.PARTNO IN (“cell range from sheet1 in spreadsheet”)
AND MT.FAC_CD = 'XX'

any help or pointer much appreciated

Cheers
Dan