Skip to Content
Jan 27, 2021 at 03:31 AM

Excel as second data provider and using it in Query Filters

34 Views Last edit Jan 27, 2021 at 03:37 PM 2 rev

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.