Excel as second data provider and using it in Query Filters

[former_member648413]

Hi All,

I am using Excel as Second data provider with 2 columns. In the main query, I am using one column as a query filter. I had 7000 VINs to pull so I was using OR clauses and filtering it 1000 At a time. When I modified the excel sheet, I had to remove all the 7 different sheets and replace them all. Basically I had to re-create the whole report again.

Is there a way that I am missing when I modify the excel, to replace it and run the query as normal?

Please keep me posted.

Thank you.